Link to home
Start Free TrialLog in
Avatar of johnnyg123
johnnyg123Flag for United States of America

asked on

Call Multiple stopred procs from a stored proc

I know it is possible to called stored procs from a stored proc by using the exec statement

I have a stored proc that has the following statements


EXEC spDeptAuditReportEmails_RetrieveAllData


EXEC spDeptAuditReportEmails_FilterDataByDepartment


How can I check to make sure the return code from spDeptAuditReportEmails_RetrieveAllData is successful before calling

EXEC spDeptAuditReportEmails_FilterDataByDepartment
ASKER CERTIFIED SOLUTION
Avatar of DcpKing
DcpKing
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of johnnyg123

ASKER

Perfect ....Thanks Mike!
My pleasure!

Have a great weekend

Mike