GilaMonster (1/17/2013)
Also, since this is SQL 2008, have a read up on Grouping Sets. They allow a lot more flexibility than cube and rollup do.
Especially since WITH CUBE and WITH ROLLUP are being deprecated.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA