This discussion is archived
7 Replies Latest reply: Jan 3, 2013 3:41 AM by BluShadow RSS

Execute Stored Procedure from another Stored Proc output

936666 Newbie
Currently Being Moderated
Hi,
Is there any example to see how to work on the below condition
exec Sp1 param1 in, param2 in,param3 in,param4 in, param5 out
on successful completion of the above

output param5 of sp1 is input of sp2 param1 with additional parameters
exec sp2 param1 in, param2 in,param3 out  
output param3 of sp1 is input of sp3 param1 with additional parameters
exec sp3 param1 in, param2 in 
Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points