Post reply

very simple Insert into

  • September 4, 2018 at 3:38 pm

    #362298

    I am embarrassed for even asking this...
    I can't seem to even get this to work . .

    SELECT * into #temp2
    From
    (Select
    SUPPLIER_ID
    From
    SOLICIT.GTM_DOC D
    ) as test

    It returns 0 rows. This is part of a bigger query and i narrowed it down this far and even this won't work. There are thousands of Supplier_IDs in the From table.

    thanks

  • September 4, 2018 at 4:32 pm

    #2004444

    jeffshelix - Tuesday, September 4, 2018 3:38 PM

    I am embarrassed for even asking this...
    I can't seem to even get this to work . .

    SELECT * into #temp2
    From
    (Select
    SUPPLIER_ID
    From
    SOLICIT.GTM_DOC D
    ) as test

    It returns 0 rows. This is part of a bigger query and i narrowed it down this far and even this won't work. There are thousands of Supplier_IDs in the From table.

    thanks

    Have you tried this?

    SELECT
    SUPPLIER_ID
    INTO
    #temp2
    From
    SOLICIT.GTM_DOC D;

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

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