Set a SpareDate Field to Server Date IF Stock is less than 5.

See more:

SQL

SQL-Server-2008R2

Hi Guys,

I was wondering if you could give me a hand here please.. I'm trying to write a bit of SQL Which I will run a a Job that will scan the StockItem table and Update a SpareDate field with the Server Date IF the Stock Quantity is under 5.

I think I am along the correct lines but wanted to check you all the SQL Guru's out there if possible :)

DECLARE @Date DATE
SET @Date = GETDATE()

UPDATE Sage200DemoData.dbo.StockItem
SET SpareDate3 =
CASE
WHEN FreeStockQuantity <= '5' THEN SpareDate3 = @Date
END

However I think I have the wrong syntax near the '=' sign.

Any pointers would be great! :) Many thanks.