Alan.B (8/29/2013)
Koen did a great job explaining your query. I just wanted to include a couple alternatives that do the same thing and are easier to understand.
Sure, the XML PATH query is easier to understand 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP