Also see Cross Apply and Outer Apply (MSSQL), often it is faster than using many CASE statements https://www.mssqltips.com/sqlservertip/1958/sql-server-cross-a

Also see Cross Apply and Outer Apply (MSSQL), often it is faster than using many CASE statements https://www.mssqltips.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/ https://www.mssqltips.com/sqlservertip/1958/sql-server-cross...