Left outer join query used for UNPIVOT by SQL Server I’m trying to understand the implementation details for UNPIVOT Operator designed by SQL Server.