Aggregation in SQL Server 2008
-
Comments posted to this topic are about the item Aggregation in SQL Server 2008
Bhavesh
.NET and SQL Server Blog -
How come Dec 3, 2009 question appeared on sep 14th?
SQL DBA.
-
I have parse the query in the query analyzer and got the following error:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'SETS'.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't." -
This was removed by the editor as SPAM
-
SanjayAttray (9/14/2009)
How come Dec 3, 2009 question appeared on sep 14th?I am surprised too!
Bhavesh
.NET and SQL Server Blog -
That's a question from the future! Are we sure on Dec 3rd the answer will be the same?
Kind of like those DOTS (Ice cream of the future!)
-
Don't know how..when I opened QOD page today it shows that "My answer is correct" and I have been given 2 points. Infact I had not even seen the question...
-
San-847017 (12/2/2009)
Don't know how..when I opened QOD page today it shows that "My answer is correct" and I have been given 2 points. In fact I had not even seen the question...Lucky you! I got wrong when the page opened - not saying however if I would have got it right if I had seen the question though! - Well yes of course I would have done
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx -
Stuart Davies (12/3/2009)
San-847017 (12/2/2009)
Don't know how..when I opened QOD page today it shows that "My answer is correct" and I have been given 2 points. In fact I had not even seen the question...Lucky you! I got wrong when the page opened - not saying however if I would have got it right if I had seen the question though! - Well yes of course I would have done
I lucked out too and got it right, though I can't recall whether I answered it back on 9/14. Pleasant surprise - and I'll take it, given the previous times when I thought I was "robbed" out of a point or two.
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Its a back to the future moment.
A fine demonstration how past performance can affect future rewards.
-
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.:crying:
-
This is a nice feature introduced in SQL2008.
Hiren Shah
:kiss:KISS (Keep It Simple Stupid) :kiss:
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply