----------------------------------------------------------- New Message on cochindotnet
----------------------------------------------------------- From: jacobseb Message 1 in Discussion Hi All, I have made a few blog posts on generating subtotal/total rows as part of the query results, this week. These posts examine different options using COMPUTE BY, WITH ROLLUP, WITH CUBE, enhancements to WITH CUBE and WITH ROLLUP the new GROUPING SETS() function added to SQL Server 2008. You can find the posts here: 1. How to add a total line to the query result (http://www.sqlserverandxml.com/2008/09/tsql-lab-4-how-to-add-total-line-to.html) 2. Using WITH ROLLUP to generate Subtotals and Grand Total rows (http://www.sqlserverandxml.com/2008/09/tsql-lab-5-using-with-rollup-to.html) 3. Using WITH CUBE to generate subtotal and grand total rows (http://www.sqlserverandxml.com/2008/09/tsql-lab-6-using-with-cube-to-generate.html) 4. Enhancements to ROLLUP and CUBE in SQL Server 2008 (http://www.sqlserverandxml.com/2008/09/tsql-lab-7-enhancements-to-rollup-and.html) 5. GROUPING SETS() - New Grouping function introduced in SQL Server 2008 (http://www.sqlserverandxml.com/2008/09/tsql-lab-8-grouping-sets-new-grouping.html) I would be glad to hear your comments on those posts. Regards Jacob Sebastian, SQL Server MVP ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/CochinDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]