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