SELECT @Setting = COALESCE((CASE
                WHEN @capName = 'role1'
                    AND .....?
                    THEN 1
                ELSE 0
              END), 1)
FROM table1 t
WHERE t.accountId = 'nameA'
AND t.capName IN ('role1','role2')