Home Forums SQL Server 2008 T-SQL (SS2K8) How to report on historical movements within a changing hierarchy RE: How to report on historical movements within a changing hierarchy

  • March 22, 2013 at 1:57 am

    #1599681

    Has anyone else had a similar problem and solved it with something other than slowly changing dimension?

    Yes, solved it with start-end dates and cte packed into a function (instead of a hierarchyid data type).

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths