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