SELECT
CASE WHEN (A9 = A8) AND (L8 = 'MoreThan1')
THEN 'MoreThan1'
ELSE CASE WHEN (A9 = A8)
THEN CASE WHEN (E9 = E8)
THEN 'OneStop'
ELSE 'MoreThan1'
END
ELSE 'OneStop'
END
END
FROM myTable
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP