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 Tuesday, August 30, 2011 7:12 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
Tom.Thomson (8/30/2011)
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?

Thank you Tom.
It was your reply to my comments that inspired me to write this question.
So I would call it inspiration before plagerism.

This question is based on one posted before.
http://www.sqlservercentral.com/questions/T-SQL/64301/
The example scripts, and the answer, are not the same.
Post #1167480
Posted Tuesday, August 30, 2011 7:18 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
stewartc-708166 (8/30/2011)
Nice simple question.
Having recently embarked on a project which requires the use of grouping sets really helped

This helped me with some recent reporting projects also.
Post #1167493
Posted Tuesday, August 30, 2011 7:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:36 PM
Points: 2,818, Visits: 2,565
I did a little reading, got the question right, but the reading I did makes me want to read a lot more about commands I have not used in the past that I think I will find quite useful. Thanks
Post #1167514
Posted Tuesday, August 30, 2011 8:01 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
Daniel Bowlin (8/30/2011)
I did a little reading, got the question right, but the reading I did makes me want to read a lot more about commands I have not used in the past that I think I will find quite useful. Thanks

You are very welcome Daniel. Thank you for the response!
Post #1167552
Posted Tuesday, August 30, 2011 8:49 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:43 PM
Points: 4,126, Visits: 3,428
Thank you, Dee! It compelled me to re-read GROUPING SETS.
Post #1167589
Posted Tuesday, August 30, 2011 8:56 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
Revenant (8/30/2011)
Thank you, Dee! It compelled me to re-read GROUPING SETS.

Thank you Revenant. It is a great new feature for grouping and set based query.
Post #1167598
Posted Tuesday, August 30, 2011 9:19 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:46 AM
Points: 900, Visits: 1,269
Thanks for this question. As a relative newbie I think I will find this useful in future.
Post #1167619
Posted Tuesday, August 30, 2011 11:25 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
tim.kay (8/30/2011)
Thanks for this question. As a relative newbie I think I will find this useful in future.

It can really cut down on the number of times you use UNION ALL.
Post #1167718
Posted Tuesday, August 30, 2011 4:34 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 7,804, Visits: 9,556
SanDroid (8/30/2011)
Thank you Tom.
It was your reply to my comments that inspired me to write this question.
So I would call it inspiration before plagerism.

This question is based on one posted before.
http://www.sqlservercentral.com/questions/T-SQL/64301/
The example scripts, and the answer, are not the same.

The important difference, I think, is that in your version the answer is right while in the previous version the answer was wrong.


Tom
Post #1167854
Posted Tuesday, August 30, 2011 11:43 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 4:16 AM
Points: 330, Visits: 197
Hi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.
Post #1167891
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse