SQL Server UNPIVOT

How to use a SQL Server unpivot query to transform columns to rows? It’s possible with this simple T-SQL un-pivot function example. The T-SQL Unpivot function can do it in one single query. It is the exact opposite of the PIVOT query. In this example, only the six first months of the year are used as columns, namely January to June. But you can … Continue reading SQL Server UNPIVOT