capturing result set output into a variable?

[katbear]

Never thought about this before. But I'm calling a stored proc from a stored proc. The inside proc returns a couple rows to the screen, like this:

This is the sp output...
NULL

I want to capture the first row (message) into a variable. How would I do this??

Thanks much

 

[SQLDenis]

use an output parameter if you can modify the called proc if not then insert exec into a temp table and select into a variable from there

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[katbear]

Not sure I understand this:

insert exec into a temp table and select into a variable from there

Not sure how I would do this in this case? I'm calling the stored proc inside a cursor multiple times, also. So there could be multiple outputs.