Related Stored Procedures

[MarceeMarc]

Can I write two (or three) stored procedures, with the second sp using a result from the first as a parameter? Thanks for any help and/or code!
MarceeMarc

 

[jmcilhinney]

A stored procedure contains SQL code. SQL code can call a stored procedure. Just as a method can call another method and assign its result to a variable in VB, so a stored procedure can call another stored procedure and assign its result to a variable in SQL.