InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 16:22:37 GMT20http://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxThank you very much for your kind feedback. Your comments are correct regarding the "link". The actual usage for this was originally to an AS400 linked server.As so often happens when you provide a tool which makes coding easier, I've now had to re-train folks so that they don't over-use the MERGE statement:)Fri, 15 Mar 2013 08:15:27 GMTGlen Schwickerathhttp://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxExcellent work. Never mind the comment about this being a solution looking for a problem, this proc was exactly what I needed. We have lots of different reference data tables what I want to keep "relatively" in sync and this gives me 99% of what I need. The other 1% I can tweak the proc to make happen. One thing, in your example 2, merging from a linked server, I believe you need to change the @srcType value sent in to 'LINK' from 'SQL'. That's what I needed to do in order to pull from the linked server. It wouldn't work otherwise.Fri, 15 Mar 2013 07:43:52 GMTchris.stamandhttp://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxThank you so much for posting this!:-)Wed, 08 Apr 2009 00:56:20 GMTbrendan.hargiehttp://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxNice Glen :)I just posted a similar SP - just went about a little different.....[url=http://www.sqlservercentral.com/scripts/SQL+2008/66507/]http://www.sqlservercentral.com/scripts/SQL+2008/66507/[/url]Tue, 07 Apr 2009 09:39:03 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxI think this procedure is impressively well done. With that said, It does seem to be a bit of a solution looking for a problem. Writing the merge statement directly is not at all challenging and it seems easier to simply do that then learn the nuances of this procedure, especially since writing it directly permits it to be made more nuanced if so desired.Tue, 07 Apr 2009 09:34:27 GMTtimothyawisemanhttp://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxWhat about using of tablediff utility?Tue, 07 Apr 2009 05:53:22 GMTleon-927648http://www.sqlservercentral.com/Forums/Topic691709-1528-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/T-SQL/66066/">Dynamic SQL Merge</A>[/B]Tue, 07 Apr 2009 00:03:32 GMTGlen Schwickerath