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