SQL 2008 MERGE using Dynamic SQL over a Linked Server

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HelmutR Ten Centuries Points: 1184 More actions · Answer 1

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 · Answer 2

Very good point Helmut, thank you!

Tommy

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

SSC Guru

Points: 76202

May 19, 2016 at 7:04 am

Thanks for the script.