SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Grouping with ROLLUP
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

geekgirl65
Starting Member

USA
2 Posts

Posted - 11/06/2013 :  17:12:29  Show Profile  Reply with Quote
I am studying for the 70-461 exam and am not finding very good documentation on when to use the specific combinations of ROLLUP.
I was taking practice exam and can't get it right, and I didn't see any of the answers that made sense.
Specifically when to use the ROLLUP outside the Grouping parentheses or inside, to get a group of subtotals for 2 out of the 5 totals columns.
Any advice or better description than in the Developer Documentation?
Thanks!

Renee

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 11/07/2013 :  04:31:36  Show Profile  Reply with Quote
http://databases.about.com/od/sql/l/aacuberollup.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sz1
Constraint Violating Yak Guru

United Kingdom
392 Posts

Posted - 11/13/2013 :  06:34:26  Show Profile  Reply with Quote
See simple ROLLUP here:
http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause/


SZ1
Please help me to enable me to help others!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000