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:
00671948
Views:
18
I've been writing a number of lengthy stored procs lately and haven't noticed this behaviour. Maybe you're doing a select into a table variable somewhere in your SP - this will cause the results to show in the grid.

Al


>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
>
>
Al Williams

Anola MB, CANADA
Previous
Reply
Map
View

Click here to load this message in the networking platform