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.
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. We empower organizations to make sense of their data with effective and modern BI solutions.
I’ve got a bit more of a writeup on the nuances of this change:
http://www.artisconsulting.com/Blogs/tabid/94/EntryID/1/Default.aspx
Overall, I think it’s a good thing.
Although a switch would could have been even better.