Posted by Erland Sommarskog on 12/15/06 16:27

(joel.sjoo@gmail.com) writes:
> I figured out the first simple step below :-)
>
> CREATE PROCEDURE [dbo].[USP_RUNJOB] AS
>
> EXEC DBO.SP_TEST1
> GO
> EXEC DBO.SP_TEST2
> GO

I don't relly know what this is supposed to be, but note that the first
GO marks the end of USP_RUNJOB, so the call to SP_TEST2 is not part of
that procedure.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
• Prev in forum: Re: Execute proceduers from another Proceduer with error handling
• Thread view: Re: Execute proceduers from another Proceduer with error handling

[Reply to this message]