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

Do you need a way to roll-up multiple rows into one row and one column. You know you can roll-up multiple rows into one row using Pivot, but you need all of the data concatenated into a single column in a single row. this tip looks at a simple approach to accomplish this.

Cube v rollup

The Difference Between Rollup and Cube

Learn about the fundamental differences between the ROLLUP and CUBE operators.

Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask

There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.

RE: Need help with a SQL Statement

Cheers!

Hardware Selection

I need some advice on how to set up the most optimal drive configuration for a new MS SQL Server machine. Which version of RAID would you choose?  Is it best to have 3 separate controllers attached to 3 separate sets of drives with one each reservered for Data, Indexes, and Transaction logs?  Or is there […]

Copying only the structure of a DB

I have a populated SQL 2000 database...and I'd like to make 2 empty copies of it....Basically, we want to populate 2 new db's with different data....but with the same structure as the original populated db.What would be the best way to do this? Thanks!

RE: locks on system tables in tempdb

Thanks Allen.  I'm showing this to the application development team.

RE: I/O errors in error log

Make sure your run them in the correct database, ie your user database.