General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Obtaining result set form SP using cursors
Hi All,
I am trying to get a result set via a stored procedure that declares a cursor and uses FETCH NEXT to populate the cursor. The problem is that the result set that is returned is a table for each row fetched.
I just ran SQL Server Service Pack 4 and prior to that I remember the FETCH procedure returning a complete dataset with rows in a single table, and not a table for each row fetched.
Any ideas?
Thanks,
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only