Another UNPIVOT Example

We saw an example of UNPIVOT in the previous post . Let us see one more UNPIVOT example in this post.  I wrote this query to help some one in one of the SQL Server forums. Here is the source data: /* SquadID Date Area01 Area02 Area03 Area04 Area05...

An example using UNPIVOT (Transforming Columns to Rows)

In the previous post we discussed the PIVOT operator introduced by SQL Server 2005. We saw how to transform ROWS to COLUMNS using the PIVOT operator. This is the source data that we examined in the previous post. /* id --------- -- 1 2 3 4 5 6 7 8 9 10...