CREATE TRIGGER [dbo].[FIS_TURU_GUNCELLE] ON [dbo].[LG_011_05_ORFICHE]
FOR INSERT
AS
BEGIN
DECLARE @cliID int
DECLARE @logID int
DECLARE @TUR VARCHAR(100)
SELECT @cliID=CLIENTREF, @logID=LOGICALREF FROM INSERTED
SET @TUR = ISNULL((SELECT TOP 1 TURU FROM LG_XT1015_011 WHERE PARLOGREF=@cliID),'')
UPDATE LG_011_05_ORFICHE SET DOCTRACKINGNR=@TUR WHERE LOGICALREF=@logID
END