Post reply

SCD Implementation with TSQL

  • November 13, 2012 at 1:35 am

    #264628

    Comments posted to this topic are about the item SCD Implementation with TSQL

  • November 13, 2012 at 7:28 pm

    #1558717

    It'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.

  • November 14, 2012 at 2:15 am

    #1558802

    Bruce,

    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 .

  • May 5, 2016 at 7:15 am

    #1876828

    Thanks for the script.

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

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