rick
asked on
SP that executes 2 other SPs
Is it possible to have 1 SP execute 2 other SPs simultaneously?
Looking to have both SPs execute at the same time. Not run one, then other runs after.
Is that possible?
Something like this...?
Looking to have both SPs execute at the same time. Not run one, then other runs after.
Is that possible?
Something like this...?
CREATE PROCEDURE SP_DEMO
AS
SET NOCOUNT ON
EXEC SP_1 @SQL, @TABLE_NAME
GO
EXEC SP_2
GOASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you both for your input. Confirmed what I thought.
ASKER
Thank you both for your help. Confirmed what I thought.
A pleasure, let us know how you go. Good luck and thank you :)
Jim has offered some good ideas, otherwise you would need to submit to some external process where you are not waiting on the results.
Hmmm... Would be interesting.....