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?