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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-01 : 09:49:07
|
| Matthew writes "I have a rather extensive query which requires at least 8 fields in the GROUP BY clause. Adding WITH ROLLUP to the end of the clause quadruples the number of records returned. Is there some way to calculate a running total using SQL on larger sized queries that can be used by ASP pages? What about a running totals for as many of 14 different fields in one record? All of the literature on this feature use simple queries with 1 or 2 fields in the GROUP BY." |
|
|
|
|
|
rollup