A more efficient way to write multiple CASE statements
Here is one way to rewrite the query that should give the same results without nested CASE statements. I'm checking for NULLs first, to potentially short-circuit additional testing. I considered using a single WHEN, with an OR between each expression, but OR isn't deterministic so this may perform better. If those columns are mostly null (vs mostly filled), you could try rewriting it to test for IS NOT NULL instead of IS NULL, and see if there is a performance difference:

CASE 
    WHEN 
        Table.Column1 IS NULL
        OR Table.Column2 IS NULL
        OR Table1.Full IS NULL
    THEN 0
    WHEN
        Table.Column1 - Table.Column2 &gt;= 180
    THEN 1
    ELSE 0
END,
CASE 
    WHEN 
        Table.Column1 IS NULL
        OR Table.Column2 IS NULL
    THEN 0
    WHEN
        Table.Column1 - Table.Column2 &gt;= 180
        AND Table3.DO = 'Z'
    THEN 1
    ELSE 0
END,
CASE 
    WHEN 
        Table4.Column1 IS NULL
        OR Table.Column2 IS NULL
        OR Table2.COLUMN3 IS NULL
    THEN 0
    WHEN
        Table.Column1 - Table.Column2 &gt;= 180
    THEN 1
    ELSE 0
END,
CASE 
    WHEN 
        Table.Column1 IS NULL
        OR Table.Column2 IS NULL
        OR Table3.Full IS NULL
    THEN 0
    WHEN
        Table.Column1 - Table.Column2 &gt;= 180
    THEN 1
    ELSE 0
END,
...