Nope. CASE is not a control flow statement but its just a conditional expression.
if you really need to do it you need this
SELECT 'Active' AS Description,'Good' AS Condition
FROM Table_A
WHERE Product_ID = 'A'
UNION ALL
SELECT 'Obselete','Bad'
FROM Table_A
WHERE Product_ID = 'B'
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Case When Return Multiple Output
Posted - 01/14/2013 : 23:11:35
