String Aggregation Over the Years in SQL Server
SQL Performance
FEBRUARY 17, 2022
Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. On more than one occasion, I had to double-check the code was even mine. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. (
Let's personalize your content