Learn about different implementations of T-SQL UNPIVOT transformations. What are the best ways for converting columns into rows?
Source: Converting columns into rows in SQL Server – UNPIVOT and other
Converting columns into rows in SQL Server – UNPIVOT and other
Cybercrux 