You can achieve the same result using FOR XML but I prefer the way you can write the query using the GROUP_CONCAT approach. I am biased though, I wrote the SQLCLR objects up on CodePlex too. Let me know if your customer objects and I'll supply the XML equivalent.