A Possible Alternative to SQL UNPIVOT

Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.

Unpivot SQL Select Data

Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.

Unpivot

Dynamic table unpivot

Generate and execute dynamically select statement for unpivot table

The dynamic unpivoter.

Have you ever wanted to dynamically unpivot a table?

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.

Display rows vertically

A script to view selects of fat rows vertically with columns in alpha order

RE: How to!

SQL doesnot allow you to use derived column names in the where clause. You will have to repeat the formula in the where clause