Our company wants to upgrade from Sql Server 2005 to Sql Server 2008 and I wanna ask about:
What are the steps I should follow to upgrade from 2005 to 2008 ?
At what point should I take care of it while upgrading ?
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