Just to be clear, I think T-SQL is fine and apparently they added some string agg function so you don't have to hack XML_agg so... Something improved. But stinky spaghetti SQL is unfixable