SQL : How to get multiple columns in a single SQL CASE statement?

Published --