About this question
I need to change returned value, from select statement, based on several conditions. I tried something like that:
,CASE i.DocValue
WHEN 'F2' AND c.CondCode IN ('ZPR0','ZT10','Z305') THEN c.CondVal
ELSE 0
END as Value
Why is it not working and what is the recommended way to do this ? There will be next several WHEN conditions.