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
Sergiy
SSC Guru
Points: 110206
More actions
March 20, 2013 at 5:48 pm
#1599191
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