Hi All,I just installed sql server 2008 on my computer. In order to understand the grouping sets, I got this example from the internetCREATE TABLE Sales (EmpId INT, Yr INT, Sales MONEY)INSERT Sales VALUES(1, 2005, 12000)INSERT Sales VALUES(1, 2006, 18000)INSERT Sales VALUES(1, 2007, 25000)INSERT Sales VALUES(2, 2005, 15000)INSERT Sales VALUES(2, 2006, 6000)INSERT Sales VALUES(3, 2006, 20000)INSERT Sales VALUES(3, 2007, 24000)
when I do thisSELECT EmpId, Yr, SUM(Sales) AS SalesFROM SalesGROUP BY GROUPING SETS((EmpId, Yr), (EmpId), (Yr), ())I keep getting the error saying:Msg 102, Level 15, State 1, Line 3Incorrect syntax near 'SETS'.I am not sure what am I doing wrong, but it seems that the new features that sql server 2008 that I installed does not recognize the new features that come with sql server 2008when I go to help-> about I see sql server 2008 so I was wondering if I need to do anything to enable these new 2008 features.