dbo.ADS_TUTSBBehavior

1 create   trigger ADS_TUTSBBehavior on TSBBehavior  for Update not for Replication as begin  declare @TSBBehaviorsToCheck QBM_YSingleGUID     BEGIN
2 TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38
3) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(PTDInheritGroup) or update(PFDInheritGroup) or update(PMDInheritGroup) or update(PSIInheritGroup
4) or update(ADAInheritGroup) begin insert into @TSBBehaviorsToCheck (UID_SingleGuid ) select distinct r.uid_TSBBehavior from TSBBehavior r join deleted
5 d on r.uid_TSBBehavior = d.uid_TSBBehavior where (isnull(r.PTDInheritGroup,0) <> isnull(d.PTDInheritGroup,0) or isnull(r.PFDInheritGroup,0) <> isnull(d.PFDInheritGroup
6,0) or isnull(r.PMDInheritGroup,0) <> isnull(d.PMDInheritGroup,0) or isnull(r.PSIInheritGroup,0) <> isnull(d.PSIInheritGroup,0) or isnull(r.ADAInheritGroup
7,0) <> isnull(d.ADAInheritGroup,0) ) if 0 < (select count(*) from @TSBBehaviorsToCheck) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
8 (object, subobject, genprocid) select x.uid, null, @GenProcID from (  select a.UID_ADSAccount as uid from ADSAccount a join @TSBBehaviorsToCheck c on 
9a.UID_TSBBehavior = c.UID_SingleGuid  ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_01 declare @DBQueueElements_02
10 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from (  select a.UID_ADSContact as uid from
11 ADSContact a join @TSBBehaviorsToCheck c on a.UID_TSBBehavior = c.UID_SingleGuid  ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_02
12 end end    END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
13