I would like to know the way that I can write a CASE function in a select statement that uses another variable that is created in the same SELECT statement using another CASE function. This is exacly what I am trying to do but obviusly gives me an error because is incorrect:
SELECT
CSV_SRV_QTY,
NET_PAID,
case when NET_PAID=0 THEN 0 ELSE CSV_SRV_QTY END AS ADJUNITS1,
CASE WHEN NET_PAID<0 AND ADJUNITS1>0 THEN -(ADJUNITS1) ELSE ADJUNITS1 END AS ADJUNITS2
FROM
CSV_MSTR
;
ADJUNITS1 runs fine but when add the second variable (ADJUNITS2) it produces an error.
SELECT
CSV_SRV_QTY,
NET_PAID,
case when NET_PAID=0 THEN 0 ELSE CSV_SRV_QTY END AS ADJUNITS1,
CASE WHEN NET_PAID<0 AND ADJUNITS1>0 THEN -(ADJUNITS1) ELSE ADJUNITS1 END AS ADJUNITS2
FROM
CSV_MSTR
;
ADJUNITS1 runs fine but when add the second variable (ADJUNITS2) it produces an error.
Comment