Global Temp Tables w/XI

[cguyreports]

I have just started using BO xi. I have created two stored procedures in sql that put data in global temp tables and there are a few other procedures that reference the global temp tables. However, I can't get my procedures to run in XI that reference the global temp tables.

Any ideas on how to get this to work?
Thanks for your time and input!

 

[synapsevampire]

What does "get my prcodures to run" mean? You get an error? Wrong data returned, or?

By SQL do you mean SQL Server? SQL is a programming language common to many databases.

-k

 

[vidru]

You can also check out this whitepaper to see what the general layout of the procedures that are using the temp tables should look like:

http://support.businessobjects.com/library/kbase/articles/c2005680.asp

-dave

 

[cguyreports]

i get an error that the global temp table is not a valid table. yes, i am using sql sever. I will check out the link dave posted.

thanks very much!