opc.three (3/5/2013)
If you can use the SQLCLR here is an Aggregate Function I wrote to simplify the syntax for these types of queries that performs comparably (sometimes better, sometimes slightly worse) than the XML method you were shown...
That's flipping cool. Thanks for sharing.