Calling Stored Procedures from Stored Procedures

Proper handling of the return values when calling a stored procedure from another stored procedure can be tricky. Here is the overview of the syntax.