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-06-11 : 08:26:02
|
Gandalf writes "I have tried to use a sp in a cursor declaration, but can't make it work. Instead I had to make a #temp table where I insert the result from the sp. Then I use select * from #temp table in the cursor declaration.
Is it possible to use an sp with a cursor directly without using a temp table.
Book online does not have any examples of using sp's with cursors and the explanation of [sql-statement] could indicate that it is not possible.
TIA
/Gandalf" |
|
|
|
|
|
Stored procedure in Cursor declaration