dbo.ADS_TUTSBSpecificGroupBehavior

1create   trigger ADS_TUTSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for update not for Replication as begin declare @GenProcID varchar(38
2) = dbo.QBM_FGISessionContext('') declare @ReallyChanged QBM_YParameterList  BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select
3 top 1 1 from deleted) goto start return start: if not (update( PFDInheritOverwrite ) or update( PTDInheritOverwrite ) or update( PSIInheritOverwrite )
4 or update( PMDInheritOverwrite ) or update( ADAInheritOverwrite ) ) begin goto EndLabel end insert into @ReallyChanged(Parameter1) select ovr.ObjectKeyGroup
5 from TSBSpecificGroupBehavior ovr join deleted i on ovr.UID_TSBSpecificGroupBehavior = i.UID_TSBSpecificGroupBehavior where isnull(ovr.PFDInheritOverwrite
6,0) <> isnull(i.PFDInheritOverwrite, 0) or isnull(ovr.PTDInheritOverwrite,0) <> isnull(i.PTDInheritOverwrite, 0) or isnull(ovr.PSIInheritOverwrite,0) <>
7 isnull(i.PSIInheritOverwrite, 0) or isnull(ovr.PMDInheritOverwrite,0) <> isnull(i.PMDInheritOverwrite, 0) or isnull(ovr.ADAInheritOverwrite,0) <> isnull
8(i.ADAInheritOverwrite, 0) if @@ROWCOUNT = 0 begin goto EndLabel end declare @GUIDADSGroup QBM_YSingleGUID insert into @GUIDADSGroup(UID_SingleGuid) select
9 g.UID_ADSGroup from ADSGroup g join @ReallyChanged ch on g.XObjectKey = ch.Parameter1 if @@ROWCOUNT > 0 begin declare @DBQueueElements_ADSContactInADSGroup
10 QBM_YDBQueueRaw insert into @DBQueueElements_ADSContactInADSGroup (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_ADSContact
11 as uid from ADSContactInADSGroup uig join @GUIDADSGroup gg on uig.UID_ADSGroup = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup'
12, @DBQueueElements_ADSContactInADSGroup declare @DBQueueElements_ADSAccountInADSGroup QBM_YDBQueueRaw insert into @DBQueueElements_ADSAccountInADSGroup
13 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_ADSAccount as uid from ADSAccountInADSGroup uig join @GUIDADSGroup
14 gg on uig.UID_ADSGroup = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_ADSAccountInADSGroup end
15  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH EndLabel: return end 
16