Home Forums SQL Server 2008 SQL Server 2008 - General elegant strategies for complex update statements? RE: elegant strategies for complex update statements?

  • April 4, 2013 at 12:03 pm

    #1603682

    sql has the ability to update a table based on another table, you just need to get used to the syntax.

    the advantage is it would be set based,and allow you to avoid a cursor or loop.

    If you can post some details, we could help

    UPDATE myTarget

    here's a mockup example:

    UPDATE myTarget

    SET myTarget.ColumnName = OtherTable.OtherColumnName

    FROM myRealTable myTarget --an alias on the real table to update

    LEFT OUTER JOIN OtherTable

    ON myTarget.PK = OtherTable.PK

    WHERE myTarget.StatusColumn IS NULL

    AND OtherTable.ProcessedDate IS NOT NULL

    SET myTarget

    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!