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. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( But is it the most efficient? FavoriteBands.
Let's personalize your content