Posts Tagged ‘ dynamic column pivot ’

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