troubleshooting Question

stored procedure runs several others cannot use go

Avatar of Craig Lambie
Craig LambieFlag for Australia asked on
Microsoft SQL Server 2005
3 Comments1 Solution188 ViewsLast Modified:
Hi Experts,

I have a SP that I runs several other SPs as part of a Morning Batch Job.

The first SP doesn't appear to run correctly.
I would like to add "GO" statement after each EXEC spXXX however that just cuts the Parent SP down.

Syntax ?
ALTER      PROCEDURE [dbo].[spUPDATE_ETS_DTS]
AS
 
 
EXEC spETS_MoveFromTemp
 
 
EXEC spSetPLFDTreasury
 
 
--Update tblFundsBase with GroupTypes from ETS
UPDATE tfb
SET tfb.vchGroupType = th.vchGroupCode
FROM tblFundsBase tfb INNER JOIN tblETSHierarchy th
ON tfb.vchFundCode = th.vchCompCode
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros