在SQL Server中执行嵌套case语句逻辑的最佳方式

I'm currently writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a lot of conditions.I'm currently writing an SQL Query, where a few