SQL 2008 MERGE using Dynamic SQL over a Linked Server

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  April 7, 2009 at 10:45 am

  #219712

  Comments posted to this topic are about the item SQL 2008 MERGE using Dynamic SQL over a Linked Server

  Tommy

  Follow @sqlscribe

• HelmutR

  Ten Centuries

  Points: 1184

  More actions

  March 16, 2011 at 9:30 am

  #1299448

  Thanks Tommy for this great procedure.

  But there's a problem if you want to merge a table with more than 2 columns in the PK.

  If you change

  SELECT @pk_2 = 'AND ' + @local_schema_name + '_TARGET.' + column_name + ' = ' + @local_schema_name + '_SOURCE.' + column_name

  FROM @pk_table WHERE key_seq = 2

  into

  SET @pk_2 = '';

  SELECT @pk_2 = @pk_2 + ' AND ' + @local_schema_name + '_TARGET.' + column_name + ' = ' + @local_schema_name + '_SOURCE.' + column_name

  FROM @pk_table WHERE key_seq > 1;

  you can also handle tables with more than 2 columns as a PK.

  Best regards

  Helmut

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  March 16, 2011 at 10:37 am

  #1299490

  Very good point Helmut, thank you!

  Tommy

  Follow @sqlscribe

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 19, 2016 at 7:04 am

  #1880216

  Thanks for the script.