having problem in stored procedures , please help

I have to stored procedures named : sp1 and sp2

sp1 return a collection of data .

I want to call sp1 inside sp2 and get it's data and work around it .

sp1 source ( something like this ) : select * from table1

sp2source ( something like this ) :

exec (sp1) ====> here i want to get data

how is that possible .

thanks alot .

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!