Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Best example of grouping ???


Best example of grouping ???

Author
Message
vaibhav.tiwari
vaibhav.tiwari
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 334
Hi everyone,

I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them

Regards,
Vaibhav

Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
Paul White
Paul White
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10338 Visits: 11350
Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS (Books Online)
Grouping Sets In SQL Server 2008 (Craig Freedman's Blog)

Those were my first two matches using Google Search.

Paul



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9438 Visits: 9517
vaibhav.tiwari (2/20/2010)
I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them


What do you mean by "best"? What makes one example better than another for you?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Paul White
Paul White
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10338 Visits: 11350
RBarryYoung (2/21/2010)
vaibhav.tiwari (2/20/2010)
I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them
What do you mean by "best"? What makes one example better than another for you?

I might be going out on a limb here, but 'best' here seems to refer to the need to reduce the confusion level.
So, a clear, and easy-to-digest example might fit the bill?



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
vaibhav.tiwari
vaibhav.tiwari
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 334
Yes paul you understood....
because over the internet a lot of material is available but its hard to get the best example sorry example which can easily differentiate the things to make me understand the concept if all the members think their example will make me clear step by step then they are welcome.....

Regards,
Vaibhav

Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together
Kingston Dhasian
Kingston Dhasian
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3003 Visits: 5007
Did you go through the links provided by Paul??

I don't think you will get any simpler examples than that. The Craig Freedman's Blog is pretty simple and easy to understand.


Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Paul White
Paul White
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10338 Visits: 11350
Kingston Dhasian (2/22/2010)
The Craig Freedman's Blog is pretty simple and easy to understand.

Thanks for pointing that out. I thought Craig did an excellent job, but I was starting to think maybe I was wrong, and Vaibhav didn't find it useful...!



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search