Post reply

SELECT output to temp table

  • May 1, 2008 at 9:17 am

    #186083

    I need to send the output from a SELECT statement to a table, I think it should look like this...

    SELECT

    FROM

    INTO tempdb.dbo.

    However, I keep getting errors. Does anybody know how to send the output from a SELECT statement to a table? Thanks

    -Kyle

  • May 1, 2008 at 9:26 am

    #809661

    See BOL for great examples, but.....

    This will create a local temp table for you:

    Select * into #newtables from tablename

    -- You can't be late until you show up.

  • May 1, 2008 at 9:36 am

    #809669

    Thank you very much.

    -Kyle

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

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