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

  • Record consumption events against nodes the entites belong to at the moment, not entities themselve.

    Then shifting an entity to another node won't change statistics of consumption for nodes.

    _____________
    Code for TallyGenerator