Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Best example of grouping ??? Expand / Collapse
Author
Message
Posted Saturday, February 20, 2010 5:20 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 27, 2012 11:13 AM
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
Post #869628
Posted Saturday, February 20, 2010 7:09 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 9:36 PM
Points: 9,927, Visits: 11,189
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #869647
Posted Sunday, February 21, 2010 9:11 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, October 24, 2014 11:52 AM
Points: 9,294, Visits: 9,484
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."
Post #870028
Posted Sunday, February 21, 2010 10:09 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 9:36 PM
Points: 9,927, Visits: 11,189
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #870053
Posted Monday, February 22, 2010 12:45 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 27, 2012 11:13 AM
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
Post #870110
Posted Monday, February 22, 2010 3:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 2,674, Visits: 4,739
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/
Post #870190
Posted Monday, February 22, 2010 4:07 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 9:36 PM
Points: 9,927, Visits: 11,189
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #870212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse