• Thanks for helping. Here is is all cleaned up:

    USE [Database name]

    GO

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    ALTER PROCEDURE [dbo].[THIS SP NAME](

    @Dummy varchar(20)

    )

    as

    Exec [SP #1] 1

    Exec [SP #2]

    Exec [SP #3] 1

    Exec [SP #4] 1

    ...an so on...

    That's it.

    If I peak into SP #1, I see this:

    ALTER PROCEDURE [dbo].[SP #1](

    @test-2 int

    )

    AS

    Truncate table [Table Name]

    Thoughts?