Dynamic PIVOT queries in SQL Server

Problem Pivoting (or producing a “cross-tab”) is a common reporting requirement – data is stored in columns and you need to present it in rows. This was a nice feature that was added to SQL Server, but you don’t always know all of the values you need to pivot on.? In this tip we look […]