CREATE TRIGGER [dbo].[Tr_StokFiyat5Guncelle]
ON [dbo].[STOK_HAR]
AFTER INSERT
AS
BEGIN
DECLARE @CON INT
SET @CON = (SELECT COUNTER FROM INSERTED)
IF (SELECT COUNT(*) FROM STOK_HAR WHERE MODUL='FATURA' AND ISLEM LIKE '%satınalma%' and NORMALIADE=0 AND COUNTER=@CON)=1
UPDATE STOK SET
FIYAT5= (SELECT TOP 1 IDFIYAT FROM STOK_HAR WHERE MODUL='FATURA' AND ISLEM LIKE '%satınalma%' and NORMALIADE=0 AND COUNTER=@CON),
DTURU5= (SELECT TOP 1 IDTURU FROM STOK_HAR WHERE MODUL='FATURA' AND ISLEM LIKE '%satınalma%' and NORMALIADE=0 AND COUNTER=@CON)
WHERE KODU IN (SELECT TOP 1 KODU FROM STOK_HAR WHERE MODUL='FATURA' AND ISLEM LIKE '%satınalma%' and NORMALIADE=0 AND COUNTER=@CON)
END