Use local temporary(#table) table of one SP to other SP

--==================================

--Coded in Sql 2000

--It will be helpful to you for seperate a logic

--==================================

CREATE PROC BVTSP1

AS

CREATE TABLE #TEMP (ID INT)

 

INSERT INTO #TEMP

SELECT 1

UNION

SELECT 2

UNION

SELECT 3

UNION

SELECT 4

 

SELECT * FROM #TEMP

 

EXEC BVTSP2

 

GO

------------------------------------

CREATE PROC BVTSP2

AS

 

INSERT INTO #TEMP 

VALUES(16)

 

SELECT * FROM #TEMP

 

GO

 

--Also can try to Exec in other sql editor

Exec BVTSP1