Is it what you're after?
IF OBJECT_ID('Proc2') is null
exec ('CREATE PROC Proc2 as SELECT 1 as One')
GO
ALTER PROC Proc2
AS
IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
SELECT * FROM #TempTable
GO
IF OBJECT_ID('Proc1') is null
exec ('CREATE PROC Proc1 as SELECT 1 as One')
GO
ALTER PROC Proc1
AS
CREATE TABLE #TempTable (
ID INT,
Name VARCHAR(50)
)
INSERT INTO #TempTable ( ID, Name )
SELECT 1, 'Name 1'
UNION
SELECT 2, 'Name 2'
EXEC proc2
GO
EXEC Proc1
_____________
Code for TallyGenerator