Hello,
is it possible to return 3 values in a switch statement? I know the following structure does not work, but is it possible to have something like this?
SELECT CASE @f1
WHEN 1
THEN CASE WHEN EXISTS (...)
THEN CASE WHEN EXISTS (....)
THEN 1
ELSE 2
ELSE 3
WHEN 2
.....