Unpivoting Oracle Tables: A Step-by-Step Guide to Multiple Columns

Comparing Fields from Two Tables with PIVOT Query

Unpivoting Holiday Hours in SQL Server Using Dynamic SQL and Table-Valued Functions