Monday, October 20, 2008

Nested Case sql

(CASE
WHEN(Status = 'Goods Issued')
OR (Status = 'Partially Issued')
THEN IssuedQty
ELSE '0' END)
AS QTYISSUED

No comments: