Home Forums SQL Server 2008 T-SQL (SS2K8) Multiple DMLS in one when clause of MERGE Statement RE: Multiple DMLS in one when clause of MERGE Statement

  • April 18, 2013 at 1:10 am

    #1607551

    28.kanikasoni (4/17/2013)

    I want to use 2 statements in case of when matched clause

    i.e

    Update all the values of Vacancy.TB_FTSearchData

    also

    update the VacancyFTSupdated from table vacancy.TB_Vacancy

    The simple answer is - you can't. Not with SQL Server. But as has already pointed out, you could use your captured output.

    “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