SCD Implementation with TSQL

  • Federico Iori

    SSCommitted

    Points: 1625

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

  • Bruce W Cassidy

    SSChampion

    Points: 12607

    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.

  • Federico Iori

    SSCommitted

    Points: 1625

    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 .

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

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

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