Exploit advanced T-SQL querying techniques: Aggregating and pivoting data in SQL Server 2005

Take a detailed look at the internal architecture of T-SQL and unveil the power of set-based querying. Best practices, sample databases, and sample code in Inside Microsoft SQL Server 2005: T-SQL Querying help database developers and administrators master the intricacies of the programming language. Focus your investigation on data-aggregation techniques in this sample chapter. Explore the new OVER clause, tiebreakers, running aggregates, pivoting, unpivoting, custom aggregations, histograms, grouping factors, and the CUBE and ROLLUP options. Learn real-world solutions to data-aggregation problems, such as dealing with tiebreakers by using concatenation, calculating a minimum using the MAX function, pivoting, unpivoting, calculating custom aggregates by using specialized techniques, and others.

Title: Inside Microsoft SQL Server 2005: T-SQL Querying
ISBN: 0735623139
Published: March 2006
Authors: Itzik Ben-Gan (Solid Quality Learning), Lubor Kollar, Dejan Sarka
Chapter: Chapter 6: Aggregating and Pivoting Data
Published by Microsoft Press