SQL Server 2008 New Features - Grouping Sets
page 1 of 3
Published: 04 Sep 2008
Abstract
In this article, Nidal talks about the available enhancements in the group by clause of SQL Server 2008. The grouping sets feature allows the developer to group data selected in the same select statement into different groups. He examines the techniques involved with the help of relevant SQL statements followed by analysis and a screen shot.
by Nidal Arabi
Feedback
Average Rating: 
Views (Total / Last 10 Days): 18715/ 49

Introduction

With its new release, Microsoft SQL Server 2008 included some new features that some of us (as developers) will find interesting and useful. In this article about the new features of SQL Server 2008, I will try to shed some light on the grouping Sets feature (a nifty addition) as attributed to the family of T-SQL.

About The Feature

The grouping sets intended to provide a powerful grouping tool in a single SQL Statement by different fields having the same selection number of fields. This feature is especially useful in the case of collecting summary data using different criteria.

Requirements

In order to apply the article procedures, you should have installed any version of Microsoft SQL Server 2008 (Express, Standard, Developer, or Enterprise) and applied the first article of this series - SQL Server 2008 New Features - Row Constructors.


View Entire Article

User Comments

Title: Great Article   
Name: Srinivas
Date: 2008-09-04 6:28:58 AM
Comment:
Its good feature provided by Microsoft.
Thanks for sharing this






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-05-24 9:36:39 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search