ADP Update Stored Procedure
Probably a nice easy question for anyone, im a beginner to Stored Procedures and need some help getting started..
CREATE PROCEDURE "pricesupdate"
SET PRODUCTS.CURRENTSELLINGPRICE = PRODUCTS.NEWSELLINGPRICE
WHERE PRODUCTS.DATEOFPRICECHANGE = DATE AND PRODUCTS.NEWSELLINGPRICE > "0";
There's my procedure at the moment, what is wrong with it?
I keep getting the error: "Incorrect syntax near the word UPDATE". Can anyone shed some light on to what I am doing wrong here?
Thanks in advance.