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 Wednesday, August 31, 2011 7:53 AM


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: Today @ 11:29 AM
Points: 3,354, Visits: 2,001
sathishmcc (8/30/2011)
Hi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.


This feature is not available in SQL Server 2005. It works with SQL Server 2008 and newer.
Post #1168114
Posted Wednesday, August 31, 2011 7:53 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)
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 I seriously apreciate that. I respect your opinion always.
Post #1168115
Posted Wednesday, August 31, 2011 7:58 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
sathishmcc (8/30/2011)
Hi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.


That is correct. I began the question with
SQL Server 2008 introduces GROUPING SETS
so that thier would not be any confusion about the server version that supports it.
Post #1168120
Posted Wednesday, August 31, 2011 9:08 AM


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: Today @ 2:22 PM
Points: 3,466, Visits: 1,819
Great question. I love the ones that show me something new.

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com
Post #1168177
Posted Wednesday, August 31, 2011 11:42 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Got new thing . thx



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1168476
Posted Thursday, September 1, 2011 2:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, October 11, 2014 4:03 AM
Points: 1,005, Visits: 988
Interesting! according to msdn "GROUPING SETS can generate a result equivalent to that generated by a simple GROUP BY, ROLLUP or CUBE operation."

Thank you,
Iulian
Post #1168516
Posted Friday, September 2, 2011 12:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
Nice question on Grouping Sets.
Post #1169031
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse