SCD Implementation with TSQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by fediori » SCD Implementation with TSQL

SCD Implementation with TSQL

Rate Topic

Display Mode

Topic Options

Author

Message

Federico Iori

Posted Tuesday, November 13, 2012 1:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 1:33 AM
Points: 31, Visits: 261

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

Post #1383977

Bruce W Cassidy

Posted Tuesday, November 13, 2012 7:28 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, March 22, 2013 11:49 AM
Points: 945, Visits: 998

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

Federico Iori

Posted Wednesday, November 14, 2012 2:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 1:33 AM
Points: 31, Visits: 261

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 »

Permissions