Best example of grouping ???

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Best example of grouping ???

Best example of grouping ???

Rate Topic

Display Mode

Topic Options

Author

Message

vaibhav.tiwari

Posted Saturday, February 20, 2010 5:20 AM

SSC 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

Paul White

Posted Saturday, February 20, 2010 7:09 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:43 PM
Points: 10,990, Visits: 10,576

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

RBarryYoung

Posted Sunday, February 21, 2010 9:11 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

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

Paul White

Posted Sunday, February 21, 2010 10:09 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:43 PM
Points: 10,990, Visits: 10,576

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

vaibhav.tiwari

Posted Monday, February 22, 2010 12:45 AM

SSC 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

Kingston Dhasian

Posted Monday, February 22, 2010 3:23 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:21 AM
Points: 2,354, Visits: 4,389

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

Paul White

Posted Monday, February 22, 2010 4:07 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:43 PM
Points: 10,990, Visits: 10,576

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 »

Permissions