Archive for March 8th, 2010

Cross Tab Using CASE Expression, PIVOT, PIVOT with Dynamic Column Value in SQL SERVER 2005

Cross Tab Query or Report is one of the coolest features of Database Programming. Here, I am going to explain Cross Tab Query using CASE Expression and PIVOT. However, PIVOT is only available in SQL Server 2005 or later version.

Let’s create t_SaleReport table and insert some demo data in it.
Continue reading