how to this query in right syntax or right way??

Posted by MZT on Stack Overflow See other posts from Stack Overflow or by MZT
Published on 2010-05-16T18:22:30Z Indexed on 2010/05/16 18:30 UTC
Read the original article Hit count: 215

Filed under:
|

i write this query using t-sql and give me an error (Incorrect syntax near the keyword 'OR') How to write it in correct way ?

SELECT SUM(Quantity) FROM Invoices WHERE Invoices.InvoiceDocStatusID = CASE @InventoryType WHEN 1 THEN ((2)OR(1)) ELSE 2 END

© Stack Overflow or respective owner

Related posts about tsql

Related posts about sql