If one used the same method but inverted the list you have a roll up you can use for various accounting functions. Inverted list processing was one of the...

Scaling will always be a problem when resequencing with stored procedures , even with partitioning. At least this is not part of trigger design. One would use this feature sparingly.