Sign in
|
Join
|
Help
Search
Tim Kent's blog
Performance Pointing
Home
Adatis
Contact
RSS
Atom
Comments RSS
Recent Posts
An Old New Blog
HowTo: Bullet Charts in Reporting Services 2005
Bullet Charts and Sparklines in Reporting Services 2005
BI conference- Day 3
BI Conference Day 4 ;)
Tags
Analysis Services
BI conference
BIDS
Blogs
Books
Business Intelligence
Dashboards
Data Mining
MCP
MDM
MDX
Non BI
PerformancePoint
PerformancePoint Monitoring
Reporting Services
SCD
Security
SharePoint
SQL Server
SQL Server 2000
SQL Server Gemini
SSIS
T-SQL
Visual Studio
Web Service
Navigation
Home
Adatis
Blogs
Downloads
Blog Roll
Colin Kirkby
Chris Webb
Christian Wade
Darren Gosbell
Donald Farmer
Adrian Downes
Hitachi Consulting
Ben Tamblyn
Jamie MacLennan
Edward Melomed
Patrick Husting
Mosha Pasumansky
Nick Barclay
Troy Scott
Patrice Truong
Simon Sabin
Marco Russo
Sutha Thiru
Jamie Thomson
Steve Mchugh
Kirk Haselden
Offical PPS Team
Dan Meyers
Archives
November 2008 (3)
October 2008 (4)
September 2008 (3)
August 2008 (2)
July 2008 (4)
June 2008 (2)
May 2008 (3)
April 2008 (3)
March 2008 (3)
February 2008 (4)
January 2008 (2)
December 2007 (3)
November 2007 (4)
October 2007 (3)
September 2007 (4)
August 2007 (4)
July 2007 (3)
June 2007 (6)
May 2007 (3)
Browse by Tags
All Tags
»
T-SQL
(
RSS
)
SCD
SSIS
Type 2 SCDs - Calculating End Date when you only have Effective Date
Here's a quick one for creating an end date column when you only have an effective date column in your data source to work with. The secret is to join the table to itself with a greater than join on the effective date. You then use the...
Posted:
Aug 17 2008, 09:40 PM
by
Tim Kent
| with
no comments
Filed under:
SSIS
,
SCD
,
T-SQL