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 .