Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Browse by Tags

All Tags » t-sql » slowly changing dimensions

  • T-SQL: Deriving start and end date from a single effective date

    The Problem! My colleague Karl Grainger has had a T-SQL problem today that we spent a bit of brain power figuring out so I figured it was worth blogging about. The situation was that he had a slowly changing dimension that had an effective date on each row, that being the date on which that record becomes the current record for the item. ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on January 10, 2005
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems