Tags / unpivot
Avoiding Type Conversions with CROSS APPLY: Unpivoting Columns Without Conversions in SQL Server
Constructing a New Table by Aggregating Values in One Table: A Comprehensive Guide to Calculating Purchase Rates
Handling Null Values and Multiple Columns in SQL Server: Unpivot vs. Cross Apply for Better Data Transformation