Before we had STRING_AGG, I talked about how FOR XML PATH was the best way to aggregate strings.