Home Forums SQL Server 2008 SQL Server 2008 - General How to update two tables data with JOIN in Single query RE: How to update two tables data with JOIN in Single query

  • August 29, 2012 at 3:56 am

    #1531288

    purushottam2 (8/29/2012)

    I want to update in single query, other wise i have to use transaction and i can not use transaction.....

    Why not? Seems very unreasonable.

    You're using SQL Server 2008 - Google "Composable DML". You can insert into two different tables in the same statement using the OUTPUT from one of them.

    “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