Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-16 : 09:36:29
|
| Jafedo writes "I have some question,1. I have store procedure with cursor inside. Why my store procedure can't return rowset? Can I retrieve rowset that be resulted by complex store procedure?2. I want make report from rows of global temporary table that be resulted from store procedure. Every I run my report I execute my store procedure with different parameter. Is my method right if is executed in multiuser environment? What will be occurred with my global temporary table if another user executed the same report and store procedure at same time with different parameter? What method that I must aplicate to resolve my problem?" |
|
|
|
|
|
Using Global Temporary Table