• "Grouping Sets ()" is a new addition to T-SQL in 2008.

    refer SQL2008 BOL page:

    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_0evalplan/html/09f0096e-ab95-4be0-8c01-f98753255747.htm

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”