Aggregation in SQL Server 2008

  • Bhavesh-1094084

    SSC Eights!

    Points: 865

    Comments posted to this topic are about the item Aggregation in SQL Server 2008

  • SanjayAttray

    SSChampion

    Points: 13157

    How come Dec 3, 2009 question appeared on sep 14th?

    SQL DBA.

  • free_mascot

    One Orange Chip

    Points: 27168

    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

  • Bhavesh-1094084

    SSC Eights!

    Points: 865

    SanjayAttray (9/14/2009)


    How come Dec 3, 2009 question appeared on sep 14th?

    I am surprised too!

  • Steve Vassallo

    SSCommitted

    Points: 1635

    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!)

  • Joy Smith San

    SSC-Insane

    Points: 24877

    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...

  • Stuart Davies

    SSCoach

    Points: 18874

    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 questionThere 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

  • webrunner

    One Orange Chip

    Points: 29991

    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 says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Richard Sisk

    SSCrazy

    Points: 2697

    Its a back to the future moment.

    A fine demonstration how past performance can affect future rewards. 🙂

  • jim.taylor

    SSC Veteran

    Points: 228

    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:

  • Hiren Shah 3

    SSC-Addicted

    Points: 402

    This is a nice feature introduced in SQL2008.

    Hiren Shah

    :kiss:KISS (Keep It Simple Stupid) :kiss:

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply