Hi All Can you DECLARE a cursor

[LokiDba]

Hi All

Can you DECLARE a cursor so that it uses a stored procedure ie you are fetching throught the resultset of the stored procedure. This is in SQLServer 7

Thanks in advance

LokiDBA

 

[tlbroadbent]

You cannot delare a cursor that fetches the output of a stored procedure directly as in

Declare MyCursor Cursor For
Exec MyProc

However, you can insert the output of the stored procedure into a temporary table and then select from the temp table into the cursor.

Insert #temp
exec MyProc

declare mycursor cursor for
Select * From #temp Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.