Local Variable For EXEC

Create a local integer variable for EXEC calls.  Use 'EXEC @<localVariableName> = <spName> ...' when executing another stored procedure.  This writes the return value from the called procedure to the local variable.  Check the value of the local variable after the call to determine the success or failure of the called stored procedure.

Before executing a stored procedure from within another stored procedure, always explicitly set the local variable for the return value to NULL before calling EXEC.