>Guessing at what you are trying to achieve, i.e. a sum of all sums, I'd
>suggest making a denormalised view of the inner nesting and then performing
>a DSQL aggregation on that view at runtime...or put it into a selectable
>stored procedure with two nested FOR loops.

Yes, that's exactly it. I want a sum of sums. I was also thinking of
making the inner sum a computed column, and then doing a sum() on the
computed column. Is it legal to do a sum() on a computed column?

-Joe