Home Forums SQL Server 2008 SQL Server 2008 - General Converting "not in" to "not exists" RE: Converting "not in" to "not exists"

  • June 27, 2013 at 9:03 am

    #1628020

    i prefer to use aliases for my updates, because the format for SQL makes it easy to include a SELECT statement very easily, which lets me do a quick Sanity Check by running the SELECT portion with the identical criteria.

    how does this work for you?

    UPDATE MyTarget

    SET MyTarget.EstimatedDeletedDate = 1

    --highlight and execute starting at the SELECT

    --SELECT MyTarget.EstimatedDeletedDate,*

    FROM VehicleWorld MyTarget

    WHERE NOT EXISTS

    (SELECT 1 FROM VCFS_Production..CORE_VehicleAdSearch ads

    WHERE MyTarget.Vehicle_ID = ads.Vehicle_ID)

    AND MyTarget.EstimatedDeletedDate <> 1

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!