Getting started with PIVOT Queries in SQL Server 2005/2008

This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past. Let us...

Generating CROSS TAB results in SQL Server 2000

In the previous post we saw an example of the PIVOT operator introduced in SQL Server 2005. We saw a simple example that transformed rows to columns using the PIVOT operator. In this post, we will examine how to achieve this SQL Server 2000. Here is the...

Another PIVOT Query Example

Generating PIVOT/CROSS-TAB queries is one of the common requirements that we find in our day-to-day programming life. SQL Server 2005 introduced a new operator: PIVOT, which made generating pivot/cross-tab results much easier. Though the PIVOT operator...