Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SCD Implementation with TSQL Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2012 1:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:19 AM
Points: 33, Visits: 292
Comments posted to this topic are about the item SCD Implementation with TSQL
Post #1383977
Posted Tuesday, November 13, 2012 7:28 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:12 PM
Points: 758, Visits: 1,031
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.
Post #1384368
Posted Wednesday, November 14, 2012 2:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:19 AM
Points: 33, Visits: 292
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 .
Post #1384475
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse