Saturday, February 25, 2012

Access Result Set from storede procedure w/in a stored procedure

Hi All
I have a stored procedure, sp_GetNameDetail, which return a one row, multiple columns result set.
Yet I have another storede procedure which would call sp_GetNameDetail, and would like to access this result set. Is there a way I can do this?
Thanks,Two choices

Use multiple output variables
or
Use a table variable.

No comments:

Post a Comment