Handling SP output like a cursor select output. 
Author Message
 Handling SP output like a cursor select output.

How can I iterate through a resultset from an sp in the same way that I
can go through a cursor/select's output?

I want to do all this within a (caller) sp. And so handle another sp's
resultset as if it was a server cursor.

Is this possible?

(Example - I want to go through the output of  "sp_who objname" to format
it better. Maybe in this example there are server tables/views I could use
in a cursor instead, but I'd like a general solution to the problem).

Gary



Mon, 17 Sep 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Capture sp output from other sp output

2. Cursor from sp output

3. Output Multiple SELECTS in one SP

4. Using select for SP's w/ multiple output parms

5. How Get Output Param from Inside SP, calling another SP

6. OUTPUT PARAM FROM SP RETURNS NULL TO AN SP

7. output parameters and output recordsets

8. Max output length 8192 for XML output

9. Can not get output value for input/output parm

10. truncated output from sql server 7 using cold fusion to output

11. Output parameter vs Input/Output parameter

12. WISH- output extended proc results output to XML


 
Powered by phpBB® Forum Software