dbo.LDP_TATTULDAPGroup

1    create   trigger LDP_TATTULDAPGroup on LDAPGroup  for Update not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: if update(UID_AccProduct
3) begin   declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select i.XobjectKey , 'ATT-PWODecisionRule-AN'
4, 'A' from inserted i exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  declare @RecalcParameter_02 QBM_YCursorBuffer insert into @RecalcParameter_02
5 (ObjectKey1, UID1, Ident1) select b.XObjectKey, c.DecisionRule, 'A' from (select a.XObjectKey from AccProduct a join inserted i on a.UID_AccProduct = 
6i.UID_AccProduct union select a.XObjectKey from AccProduct a join deleted d on a.UID_AccProduct = d.UID_AccProduct ) b cross join (select 'ATT-PWODecisionRule-OA'
7 as DecisionRule union select 'ATT-PWODecisionRule-OrgATT' ) c exec QER_PITShopHelperFill_Recalc @RecalcParameter_02, @GenprocID end  END TRY BEGIN CATCH
8 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
9