Nothing like as elegant as that! I didn't appreciate the power of UnionAggregate and spent my time getting the rows into order, such that the end point of row-n matched with the start point of row-n+10 (and reversing the points in any rows which were "backward") because I thought that was what UnionAggregate needed. So you've done in one statement what took me a temp table, a function and a procedure.