dbo.TSB_TUTSBBehavior

1CREATE trigger TSB_TUTSBBehavior2  ON TSBBehavior FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @TSBBehaviorToCheck QBM_YSingleGUID7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    IF EXISTS(13      SELECT TOP 1 114      FROM deleted)15    GOTO start16    RETURN start:17    DECLARE @GenProcID varchar(38)18    SELECT @GenProcID = dbo.QBM_FGISessionContext('')19    IF20    UPDATE(PTDInheritGroup) OR21    UPDATE(PFDInheritGroup) OR22    UPDATE(PMDInheritGroup) OR23    UPDATE(PSIInheritGroup) OR24    UPDATE(ADAInheritGroup)25    BEGIN26      INSERT INTO @TSBBehaviorToCheck(UID_SingleGuid)27      SELECT28        DISTINCT r.uid_TSBBehavior29      FROM TSBBehavior r30      JOIN deleted d31        ON r.uid_TSBBehavior = d.uid_TSBBehavior32      WHERE33        (isnull(r.PTDInheritGroup, 0) <> isnull(d.PTDInheritGroup, 0) OR isnull(r.PFDInheritGroup, 0) <> isnull(d.PFDInheritGroup,34      0) OR isnull(r.PMDInheritGroup, 0) <> isnull(d.PMDInheritGroup, 0) OR isnull(r.PSIInheritGroup, 0) <> isnull(d.PSIInheritGroup,35      0) OR isnull(r.ADAInheritGroup, 0) <> isnull(d.ADAInheritGroup, 0))36      IF 0 <(37        SELECT count(*)38      FROM @TSBBehaviorToCheck)39      BEGIN40        DECLARE @DBQueueElements_01 QBM_YDBQueueRaw41        INSERT INTO @DBQueueElements_01(object,42        subobject,43        genprocid)44        SELECT45          x.uid,46          NULL,47          @GenProcID48        FROM(49        SELECT a.UID_UNSAccountB AS uid50        FROM UNSAccountB a51        JOIN @TSBBehaviorToCheck c52          ON a.UID_TSBBehavior = c.UID_SingleGuid53        JOIN UNSRootB r54          ON a.UID_UNSRootB = r.UID_UNSRootB AND r.GroupUsageMask & 0x01 > 0) AS x55        EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB',56          @DBQueueElements_0157        DECLARE @DBQueueElements_02 QBM_YDBQueueRaw58        INSERT INTO @DBQueueElements_02(object,59        subobject,60        genprocid)61        SELECT62          x.uid,63          NULL,64          @GenProcID65        FROM(66        SELECT a.UID_UNSAccountB AS uid67        FROM UNSAccountB a68        JOIN @TSBBehaviorToCheck c69          ON a.UID_TSBBehavior = c.UID_SingleGuid70        JOIN UNSRootB r71          ON a.UID_UNSRootB = r.UID_UNSRootB AND r.GroupUsageMask & 0x02 > 0) AS x72        EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1',73          @DBQueueElements_0274        DECLARE @DBQueueElements_03 QBM_YDBQueueRaw75        INSERT INTO @DBQueueElements_03(object,76        subobject,77        genprocid)78        SELECT79          x.uid,80          NULL,81          @GenProcID82        FROM(83        SELECT a.UID_UNSAccountB AS uid84        FROM UNSAccountB a85        JOIN @TSBBehaviorToCheck c86          ON a.UID_TSBBehavior = c.UID_SingleGuid87        JOIN UNSRootB r88          ON a.UID_UNSRootB = r.UID_UNSRootB AND r.GroupUsageMask & 0x04 > 0) AS x89        EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2',90          @DBQueueElements_0391        DECLARE @DBQueueElements_04 QBM_YDBQueueRaw92        INSERT INTO @DBQueueElements_04(object,93        subobject,94        genprocid)95        SELECT96          x.uid,97          NULL,98          @GenProcID99        FROM(100        SELECT a.UID_UNSAccountB AS uid101        FROM UNSAccountB a102        JOIN @TSBBehaviorToCheck c103          ON a.UID_TSBBehavior = c.UID_SingleGuid104        JOIN UNSRootB r105          ON a.UID_UNSRootB = r.UID_UNSRootB AND r.GroupUsageMask & 0x08 > 0) AS x106        EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3',107          @DBQueueElements_04108      END109    END110  END TRY111  BEGIN CATCH112    EXEC QBM_PSessionErrorAdd DEFAULT113    RAISERROR('',114    18,115    1)116      WITH NOWAIT117  END CATCH118  ende:119  RETURN120END