I am thinking of executing a "Master" stored procedure and executing several select statements to determine what equipment is attached to my production line. Based on the values of this first "Master" stored procedure which are now stored in several @variables, can I execute another stored procedure and pass on these @variables to this second stored procedure and so on ? Curious if this is possible and if so how it might work. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to have one stored procedure call another stored procedure
- Thread starter vamoose
- Start date
- Status
Similar threads
- Locked
- Question