Community

Rolling up multiple rows into a single row and column for SQL Server data

(Douglas P. Castilho) I need a way to roll-up multiple rows into one row and one column. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple approach to accomplish this.

Read More - Register for Free Membership