SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by fediori / SCD Implementation with TSQL / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 00:09:05 GMT20RE: SCD Implementation with TSQLhttp://www.sqlservercentral.com/Forums/Topic1383977-2632-1.aspxBruce, writing the same code I wrote using MERGE statement is not very easy , I am not sure if it is possible, and I wanted to provide code that anybody can reuse, changing table and column names.Using cross join instead of inner join .. on 1=1 of course is less confusing .Wed, 14 Nov 2012 02:15:48 GMTFederico IoriRE: SCD Implementation with TSQLhttp://www.sqlservercentral.com/Forums/Topic1383977-2632-1.aspxIt's a good start, but I would recommend you investigate the "merge" command. I'd also suggest that writing joins as "cross joins" (rather than "inner joins") where there is no join criteria will be somewhat less confusing.Tue, 13 Nov 2012 19:28:09 GMTBruce W CassidySCD Implementation with TSQLhttp://www.sqlservercentral.com/Forums/Topic1383977-2632-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SCD/93755/">SCD Implementation with TSQL</A>[/B]Tue, 13 Nov 2012 01:35:26 GMTFederico Iori