Post reply

Create a temp table in SP from another SP?

  • March 9, 2004 at 11:40 am

    #107687

    Can you create a temp table in a stored procedure from another stored procedure that returns a recordset?

  • March 9, 2004 at 1:19 pm

    #498042

    Yes.  That's typically how one deals with a set returned from a called proc.



    --Jonathan

  • March 9, 2004 at 1:44 pm

    #498048

    Probably a dumb question, but how do you call another SP from within a SP into a temp table that can be used elsewhere in the calling SP?

  • March 9, 2004 at 1:54 pm

    #498050

    CREATE TABLE #Temp(

    Col1 int,

    Col2 int)

    INSERT #Temp

    EXEC p_Test 'YourParam'

    Put all the DDL at the beginning of your calling proc to prevent excessive recompiles.



    --Jonathan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply