Efficiently Unpivoting Multiple Columns into Name and Value Pairs in SQL

Dynamic Unpivoting: A Guide to Transforming Tables with Columns of Different Types

**Unpivoting Data in SQL Server**