Home Forums SQL Server 2014 Development - SQL Server 2014 Updating a column in one table from another table RE: Updating a column in one table from another table

  • December 23, 2013 at 6:28 am

    #1675588

    Check in Books Online for UPDATE, specifically UPDATE FROM. If you are still unsure, then take the time to read the posting etiquette article linked in my signature "please read this", and post DDL for your two tables with scripts to populate them with sample data.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden