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.
You might also like
Microsoft SQL Server 2008 Feature Pack RC0, June 2008 Microsoft SQL Server 2008 Feature Pack RC0, June 2008