Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obtaining result set form SP using cursors
Message
 
 
To
24/06/2002 18:41:15
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00671813
Message ID:
00671958
Views:
16
Every query executed in SP returns a result set. If you want to return one result set, than create a temp table and populate it in SP. When processing is done do SELECT * from #temptable to return result set to the callee.

>Hi Mike,
>
>Also, do you know why the Query Analyzer would give me a "Result Grid" for each row returned from the cursor?
>
>Thanks,
>Mike
>
>
>>>I am trying to get a result set via a stored procedure that declares a cursor and uses FETCH NEXT to populate the cursor.
>>
>>This isn't clear to me. Cursors are populated by the FETCH command. Cursors are populated when opened. The FETCH just moves the value of the current position to the variables specified.
>>
>>-Mike
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform