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 21, 2013 at 11:52 am

    #1599510

    polkadot (3/20/2013)

    K, thanks for the leads guys. Anyone want to add, feel free to do so. Appreciate all the input.

    Helen

    Check the following link for the different types of SCD's especially Type 2.

    http://en.wikipedia.org/wiki/Slowly_changing_dimension

    I guess my other question would be, what type of hierarchical structure do you have? Adjacency List, HierarchyID, Hierarchical Path, Nested Sets, or ????

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)