Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Aggregation in SQL Server 2008 Expand / Collapse
Posted Thursday, December 3, 2009 9:11 AM


Group: General Forum Members
Last Login: Wednesday, October 6, 2010 7:54 AM
Points: 126, Visits: 75
Forgive me, as I am just a grasshopper! (how rude)

anyway, I too was getting:
Incorrect syntax near 'SETS'.

but I am running SQL Server 2008 Management Studio.

Figured out that the Compatibility level must be at 100 in order for this to work. This is a bummer for me, since I work with SQL Server 2005 databases (level 90 or some even set to 80). I think I could really make use of these more powerful grouping techniques, but you are stuck if you aren't using the 2008 engine.

I guess I am forced to continue to do more mental gymnastics to get these types of desired results.
Post #828286
Posted Friday, December 4, 2009 8:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 16, 2011 3:52 AM
Points: 288, Visits: 105
This is a nice feature introduced in SQL2008.

Hiren Shah

KISS (Keep It Simple Stupid)
Post #829010
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse