Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obtaining result set form SP using cursors
Message
From
24/06/2002 16:01:41
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Obtaining result set form SP using cursors
Miscellaneous
Thread ID:
00671813
Message ID:
00671813
Views:
39
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
Map
View

Click here to load this message in the networking platform