Prologika Forums
Making sense of data
Aggregate Rows and SP2

Blogs

Prologika (Teo Lachev's Weblog)

Books

Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling)Learn PowerPivot and Analysis Services-Tabular at your own pace with our latest book Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling). It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Training

Applied Microsoft SQL Server 2008 Reporting Services

We offer onsite and online Business Intelligence classes!  Contact us about in-person training for groups of five or more students.

For more information or to register click here! 

Syndication

Archives

Back to my When (null) is not Null post, there is a undocumented breaking change in SQL Server 2005 SP2 which you should be aware of. In response to the customer demand, SP2 treats aggregate rows as detail rows.  As a result, if the report doesn’t use the Aggregate() function, the report will show all rows. For those using the Aggregate function, there will be no change.


Posted Sun, Jun 10 2007 11:02 AM by tlachev
Filed under:

Comments

furmangg wrote re: Aggregate Rows and SP2
on Mon, Jun 11 2007 10:46 AM

I've got a bit more of a writeup on the nuances of this change:

www.artisconsulting.com/.../Default.aspx

Overall, I think it's a good thing.

tlachev wrote re: Aggregate Rows and SP2
on Mon, Jun 11 2007 1:45 PM

Although a switch would could have been even better.