Aggregates

Question

Post reply

Aggregates

PChiragS

SSCarpal Tunnel

Points: 4965
More actions
December 5, 2012 at 8:20 pm

#271213

Comments posted to this topic are about the item Aggregates
December 5, 2012 at 11:50 pm

This was removed by the editor as SPAM
December 6, 2012 at 6:41 am

This was removed by the editor as SPAM

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

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]

demonfox SSCertifiable Points: 6289 More actions · Answer 2

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:

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

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

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 6

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

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 7

(Bob Brown)

SSCrazy

Points: 2705

December 6, 2012 at 4:45 am

#1566094

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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 8

(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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 9

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/

ashokkumar.thangavel-639050 Newbie Points: 9 More actions · Answer 10

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.

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 11

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.

Toreador SSChampion Points: 11368 More actions · Answer 12

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