Home Forums SQL Server 2008 T-SQL (SS2K8) Passing temp table from one stored procedure to another RE: Passing temp table from one stored procedure to another

  • 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