Post reply

Trying to Insert Result Set form a LEFT JOIN Query + DTS

  • December 10, 2008 at 2:01 am

    #216386

    Please can someone help!

    So far I have managed to do the following task using DTS.

    Insert data from an excel spreadsheet into a staging table (InstrumentMF_Staging) ---> done

    I have created a SELECT Query against the destination table (InstrumentMF) to see if there is any duplicate data ---> done (please see query below)

    SELECT *

    FROM InstrumentMF_Staging

    LEFT JOIN InstrumentMF

    ON InstrumentMF_Staging.sedol=InstrumentMF.sedol

    WHERE InstrumentMF.sedol IS null

    This produces the result set that I need. The next stage is to perform an INSERT with the result set into the InstrumentMF table.

    What extra syntax do i need and how would i go about using DTS to carry this out?

    A little guidance would wonderful.

    Thanks.

  • December 10, 2008 at 3:37 am

    #910190

    sorry, wrong forum. Have re-posted this on SQL Server Newbies. Cheers.

  • December 10, 2008 at 5:41 am

    #910249

    Thread continues: http://www.sqlservercentral.com/Forums/Topic616816-1291-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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