I provide four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.

I take a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.

Tip : SQL Server Video – Tricks to play on your DBA – 1

I use a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.

I show the safest and most efficient ways to perform grouped concatenation in SQL Server.