dbo.LDP_TATTULDPDomain

1    create   trigger LDP_TATTULDPDomain on LDPDomain  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted
2) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext
3('') if update(uid_AERoleOwner) begin     declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select
4 i.XobjectKey , 'TSB-PWODecisionRule-EN', 'A' from inserted i  insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select bt.XobjectKey, 'TSB-PWODecisionRule-SO'
5, 'A' from inserted i join basetree bt on i.uid_AERoleOwner = bt.UID_Org insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select bt.XobjectKey
6, 'TSB-PWODecisionRule-SO', 'A' from deleted d join basetree bt on d.uid_AERoleOwner = bt.UID_Org exec QER_PITShopHelperFill_Recalc @RecalcParameter_01
7, @GenprocID  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
8