Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  can someone explain this "rollup" thing to me

Author  Topic  furiouZ Starting Member 1 Post Posted - 2001-07-27 : 17:16:41 I have a pretty decent sized query which returns 19 values of which about 13 of them are sum values. It would save me a lot of front end code and time if I could have TSQL sum up the various rows whenever a change in say column 1 (for example) occurs. The problem I run into is that I MUST (according to query analyzer) have at least 8 of the fields in the GROUP BY clause. When "WITH ROLLUP" is added to this clause, the number of records returned is quadrupled at least. What are the capabilities/limitations of ROLLUP and is it possible to have SQL return my desired results?