Trans SQL - procedure return

Inside my procedure B I do something like this…

Exec procedure A which returns…

ID NAME
1 Jerry
2. Elaine
3 Kramer

I’d like to extract first row and save it into variable so I can use it in my procedure B.

How would I do this?

Thanks

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.