• 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