SQL Server 2008 New Features - Grouping Sets: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
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): 16484/ 27

Article Contents:

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

(Page 2) »

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