Home Forums SQL Server 2008 T-SQL (SS2K8) Change case logic to boolean logic RE: Change case logic to boolean logic
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 5, 2013 at 3:49 pm
#1604164
Don't think you can get it without added an addition WHEN clause to the CASE for t2. You are getting a null where c1 = 1 in t1 because you have no ELSE clause for the outer CASE used to determine t1.