SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Tommy Bollhofer / SQL 2008 MERGE using Dynamic SQL over a Linked Server / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:27:24 GMT20RE: SQL 2008 MERGE using Dynamic SQL over a Linked Serverhttp://www.sqlservercentral.com/Forums/Topic692289-882-1.aspxVery good point Helmut, thank you!Wed, 16 Mar 2011 10:37:32 GMTTommy BollhoferRE: SQL 2008 MERGE using Dynamic SQL over a Linked Serverhttp://www.sqlservercentral.com/Forums/Topic692289-882-1.aspxThanks 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[code="sql"]SELECT @pk_2 = 'AND ' + @local_schema_name + '_TARGET.' + column_name + ' = ' + @local_schema_name + '_SOURCE.' + column_name FROM @pk_table WHERE key_seq = 2[/code]into [code="sql"]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 &gt; 1;[/code]you can also handle tables with more than 2 columns as a PK.Best regardsHelmutWed, 16 Mar 2011 09:30:31 GMTHelmut RothtauscherSQL 2008 MERGE using Dynamic SQL over a Linked Serverhttp://www.sqlservercentral.com/Forums/Topic692289-882-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SQL+2008/66507/">SQL 2008 MERGE using Dynamic SQL over a Linked Server</A>[/B]Tue, 07 Apr 2009 10:45:09 GMTTommy Bollhofer