R
RSunday
I have a cost structure where a cost can be the sum of similar "children"
cost records. The hierarchy is given by a costID and a ParentCostID.
Now for a certain level of parent cost records I want to get the sum of
possible "children cost records". I can write code to loop through the
records, but would like to just run a query.
How is that done?
cost records. The hierarchy is given by a costID and a ParentCostID.
Now for a certain level of parent cost records I want to get the sum of
possible "children cost records". I can write code to loop through the
records, but would like to just run a query.
How is that done?