The following update query is giving error-- "The operation must use an updatable query" while running...
PLZ help!!
UPDATE MEASUREMENT SET STATUS = ( IIF(
(SELECT SUM(QNTY) FROM Measurement_Individual_Delivery WHERE Measurement_Key_FK=[@KEYS] ) < (SELECT QUANTITY FROM MEASUREMENT WHERE KEYS=[@KEYS]) , 'Pending','Delivered'))
WHERE KEYS=[@KEYS];