create trigger TRUMemoMerge on Documents after INSERT,UPDATE as if ((select TRIGGER_NESTLEVEL()) < 2) begin declare @memo_before varchar(max) = (select cast(memo as varchar(max)) from deleted) declare @memo_after varchar(max) = (select cast(memo as varchar(max)) from inserted) if ( @memo_after not like @memo_before ) begin declare @vorid int = (select vorid from inserted) declare @belid int = (select belid from inserted) update Documents set Memo = @memo_after where VorID = @vorid and BelID <> @belid end end