Aggregates

  • Comments posted to this topic are about the item Aggregates

  • Nice back to basics question - thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • bitbucket-25253 (12/5/2012)


    Nice back to basics question - thanks

    +1

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • An easy one for today. Thanks for posting!

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • This was removed by the editor as SPAM

  • Stewart "Arturius" Campbell (12/5/2012)


    Interesting question, thanks.

    just bear in mind that GROUPING_ID only came into effect with SQL2008. Those still using 2005 will not have knowledge hereof...

    Well said! This seems to be the reason most of the respondents' are trapped in "GROUPING_ID " option 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Nice easy question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I wasn't certain about GROUPING_ID, but BOL cleared it up. 🙂

  • Thanks for the easy point. I needed it this week!

  • (Bob Brown) (12/6/2012)


    Thanks for the easy point. I needed it this week!

    +1

    The next one should be -

    Which one is not a fruit:

    a. banana

    b. apple

    c. orange

    d. They are all fruit

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am surprised that so many people here consider this to be a simple question. However, the good news is that those people will probably be able to explain me something.

    According to the Merriam-Webster English dictionary, the verb "to aggregate" is defiend as "to collect or gather into a mass or whole" (http://www.merriam-webster.com/dictionary/aggregate?show=0&t=1354796918). I checked it, just to make sure, but I am glad that the dictionary definition matches what I consider aggregation to be.

    Now I have no problem with CHECKSUM_AGG and STDEVP. Both collect data from multiple rows, and generate a single value from that, be it a checksum value, or the standard deviation of the data collected. No problem. But, and here is the question I hope someone will answer me:

    Exactly WHAT is aggregated by the GROUPING_ID function??


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Hi

    I need a favor here.. Guys, could you please help me on this below scenario,

    I have one ssis 2005 package, in this running one sp which will return the result set n stored into one SSIS dataset variable. now the dataset say will have 100 records. what it will do in the current process is, it will fetch one by one in for each loop and get details and generates crystal report. like that it will do it for 100 times.

    my requirement is, instead of looping 100 times, i have to reduce the no of times. i need to do it some parellel processing which will reduce the running time of generating 100 reports. please provide me a solution.

    Thanks in advance.

  • Hugo Kornelis (12/6/2012)


    I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am surprised that so many people here consider this to be a simple question. However, the good news is that those people will probably be able to explain me something.

    According to the Merriam-Webster English dictionary, the verb "to aggregate" is defiend as "to collect or gather into a mass or whole" (http://www.merriam-webster.com/dictionary/aggregate?show=0&t=1354796918). I checked it, just to make sure, but I am glad that the dictionary definition matches what I consider aggregation to be.

    Now I have no problem with CHECKSUM_AGG and STDEVP. Both collect data from multiple rows, and generate a single value from that, be it a checksum value, or the standard deviation of the data collected. No problem. But, and here is the question I hope someone will answer me:

    Exactly WHAT is aggregated by the GROUPING_ID function??

    I can only answer that when I research a QotD, I stay away from the Merriam-Webster English dictionary and look it up in the Microsoft dictionary, Books Online.

  • This was removed by the editor as SPAM

  • Hugo Kornelis (12/6/2012)


    Exactly WHAT is aggregated by the GROUPING_ID function??

    That's exactly the conversation I had with myself. Was this a trick question or not? In the end I went with the right answer, though was expecting to be told I was wrong...

Viewing 15 posts - 1 through 15 (of 38 total)

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