sql statement (where clause)

[dynodave]

I have this sql statement and i need to include Rec_Qty and Del_Qty in the where clause how is this possible please

SELECT depot, loadno, partno, quantity,
case when type = 'S' THEN
quantity * -1
ELSE
0.00
END Rec_Qty,
CASE WHEN type <> 'S' THEN
quantity
ELSE
0.00
END Del_Qty
FROM dbo.moves
WHERE depot BETWEEN @DepFrom and @DepTo
AND loadno BETWEEN @LoadFrom and @LoadTo

 

[swampBoogie]

You can use a derived table, e.g.

select * from (
SELECT depot, loadno, partno, quantity,
case when type = 'S' THEN
quantity * -1
ELSE
0.00
END Rec_Qty,
CASE WHEN type <> 'S' THEN
quantity
ELSE
0.00
END Del_Qty
FROM dbo.moves
WHERE depot BETWEEN @DepFrom and @DepTo
AND loadno BETWEEN @LoadFrom and @LoadTo
) dt
where req_qty = -4711
and del_qty = 4711