Merge Tables in SQL 2005

• rka

  SSCommitted

  Points: 1599

  More actions

  June 14, 2011 at 8:27 pm

  #239918

  Comments posted to this topic are about the item Merge Tables in SQL 2005

• Infostar

  SSC Veteran

  Points: 264

  More actions

  June 16, 2011 at 7:56 am

  #1339720

  I think you missunderstand the MERGE query in SQL2008. MERGE is a shortcut for performing insert, update, or delete operations on a target table based on the results of a join with a source table, all in a single query. It operates on rows not on columns. However your script is interesting for the problem it solves and it should be useful even in SQL2008.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 12, 2016 at 7:38 am

  #1878632

  Thanks for the script.