CREATE PROC SIPARIS_SIL
@CODE INT,@USER_ID INT
AS
BEGIN
UPDATE [STOK_RAPOR_SIPARISLER]
SET [AMOUNT]=0
WHERE STOCKREF= (SELECT LOGICALREF FROM LG_011_ITEMS WHERE CODE= @CODE ) AND TYPE_=1 AND DEL_=0 AND AMOUNT>0 AND ORDERDATE IS NOT NULL AND USERID=@USER_ID
END