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 123»»»

Grouping Sets Expand / Collapse
Author
Message
Posted Monday, August 29, 2011 8:12 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Comments posted to this topic are about the /questions/Aggregates/75489/ "Grouping Sets"

This question was inspired by one posted before.
http://www.sqlservercentral.com/questions/T-SQL/64301/
Post #1167272
Posted Monday, August 29, 2011 10:57 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 3,388, Visits: 2,021
Thanks for the question. Still haven't really played with this feature yet. I could see how some reports might be easier to read using this syntax.
Post #1167300
Posted Tuesday, August 30, 2011 12:02 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 17,967, Visits: 15,979
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1167311
Posted Tuesday, August 30, 2011 1:05 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 4,119, Visits: 5,482
Nice simple question.
Having recently embarked on a project which requires the use of grouping sets really helped


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1167322
Posted Tuesday, August 30, 2011 3:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:45 AM
Points: 7,860, Visits: 9,606
Nice and straightforward.

I have a strange feeling that I've seen exactly those two queries before somewhere.

But maybe I won't cry "plagiarism" .

Or maybe I should?


Tom
Post #1167371
Posted Tuesday, August 30, 2011 5:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 1,262, Visits: 13,557
nice question!!!
Good example to use the GROUPING SETS operator



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1167392
Posted Tuesday, August 30, 2011 5:30 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 3:46 AM
Points: 2,223, Visits: 177
Nice Question.
Post #1167405
Posted Tuesday, August 30, 2011 5:44 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Nice learning question, thanks.

http://brittcluff.blogspot.com/
Post #1167410
Posted Tuesday, August 30, 2011 7:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Thank you everyone so far for the positive comments.
I truely apreciate all your feedback.
Post #1167468
Posted Tuesday, August 30, 2011 7:06 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:32 PM
Points: 581, Visits: 733
Thanks for the question. This is a feature I have not been able to play with too much, but one that I can see some uses for.

Matt
Post #1167471
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse