SCD Implementation with TSQL

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

  • 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.

  • 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 .

  • 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