Back to OIM Explorer

dbo.RMS_TUESetHasEntitlement

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ESetHasEntitlement. Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8; Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8; Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8; Bulk DBQueue insert -> <Key><T> at line 8

Source: sandbox-db sys.sql_modules

Source size: 7.845 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8
  • Bulk DBQueue insert -> <Key><T> at line 8
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 19
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 19
  • Bulk DBQueue insert -> <Key><T> at line 19
  • Bulk DBQueue insert -> <Key><T> at line 19
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 22
  • Bulk DBQueue insert -> <Key><T> at line 22
  • Bulk DBQueue insert -> <Key><T> at line 22
  • Bulk DBQueue insert -> at line 22
  • Bulk DBQueue insert -> <Key><T> at line 31
  • Bulk DBQueue insert -> <Key><T> at line 31
  • Bulk DBQueue insert -> at line 31
  • Bulk DBQueue insert -> <Key><T> at line 40
  • Bulk DBQueue insert -> at line 40
  • Bulk DBQueue insert -> at line 49
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: ESetHasEntitlement

Typed Edges

  • queues DBQueue task RMS_ZESetHasEntitlement at line 8 Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 8
  • queues DBQueue task <Key><T> at line 8 Bulk DBQueue insert -> <Key><T> at line 8
  • queues DBQueue task RMS_ZESetHasEntitlement at line 19 Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 19
  • queues DBQueue task <Key><T> at line 19 Bulk DBQueue insert -> <Key><T> at line 19
  • queues DBQueue task RMS_ZESetHasEntitlement at line 22 Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 22
  • queues DBQueue task <Key><T> at line 22 Bulk DBQueue insert -> <Key><T> at line 22
  • queues DBQueue task at line 22 Bulk DBQueue insert -> at line 22
  • queues DBQueue task <Key><T> at line 31 Bulk DBQueue insert -> <Key><T> at line 31
  • queues DBQueue task at line 31 Bulk DBQueue insert -> at line 31
  • queues DBQueue task <Key><T> at line 40 Bulk DBQueue insert -> <Key><T> at line 40
  • queues DBQueue task at line 40 Bulk DBQueue insert -> at line 40
  • queues DBQueue task at line 49 Bulk DBQueue insert -> at line 49
  • trigger on table ESetHasEntitlement Trigger parent table: ESetHasEntitlement
  • references source dbo.QBM_FGIBitPatternXOrigin source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGIXOriginChanged_Effect source text reference
  • references source dbo.QBM_FGIXOriginChanged_Except2 source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.RMS_TUESet source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL312 lines
1CREATE trigger RMS_TUESetHasEntitlement2  ON ESetHasEntitlement FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @EsetOperation varchar(38)7  DECLARE @EsetTable varchar(30)8  DECLARE @DebugSwitch int = 09  DECLARE @DebugMessage nvarchar(max)10  DECLARE @ElementLast int11  DECLARE @ElementBufferMulti QBM_YCursorBuffer12  DECLARE @ElementCount int13  DECLARE @ElementIndex int14  DECLARE @QBM_BitPatternXOrigin_Direct int = dbo.QBM_FGIBitPatternXOrigin('|Direct|',15  0)16  DECLARE @DBQueueElements_spezial QBM_YDBQueueRaw17  DECLARE @XUser nvarchar(64) = object_name(@@procid)18  DECLARE @Xdate datetime = getutcdate()19  DECLARE @UID_TaskFollow varchar(38)20  BEGIN TRY21    IF EXISTS(22      SELECT TOP 1 123      FROM deleted)24    GOTO start25    IF EXISTS(26      SELECT TOP 1 127      FROM inserted)28    GOTO start29    RETURN start:30    DECLARE @GenProcID varchar(38)31    SELECT @GenProcID = dbo.QBM_FGISessionContext('')32    IF33    UPDATE(XOrigin)34    BEGIN35      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw36      INSERT INTO @DBQueueElements_01(object,37      subobject,38      genprocid)39      SELECT40        x.uid,41        NULL,42        @GenProcID43      FROM(44      SELECT45        DISTINCT d.UID_ESet AS uid46      FROM deleted d47      JOIN ESetHasEntitlement dd48        ON d.XObjectKey = dd.XObjectKey49      WHERE50        dbo.QBM_FGIXOriginChanged_Except2(d.XOrigin, dd.XOrigin) = 1) AS x51      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement',52        @DBQueueElements_0153    END54    IF55    UPDATE(XOrigin) AND NOT56    UPDATE(XIsInEffect)57    BEGIN58      UPDATE ESetHasEntitlement59      SET XIsInEffect = 1,60      XDateUpdated = @Xdate,61      XUserUpdated = @XUser62      FROM ESetHasEntitlement ehe63      JOIN deleted d64        ON ehe.UID_ESetHasEntitlement = d.UID_ESetHasEntitlement65      WHERE66        d.XOrigin = 0 AND ehe.XOrigin & @QBM_BitPatternXOrigin_Direct > 0 AND ehe.Entitlement NOT LIKE '<Key><T>ESet</T>%'67    END68    IF69    UPDATE(XIsInEffect) OR70    UPDATE(XOrigin)71    BEGIN72      IF @DebugSwitch > 073      BEGIN74        SELECT @DebugMessage = OBJECT_NAME(@@procid) + ' stelle 1' print @DebugMessage75      END76      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw77      INSERT INTO @DBQueueElements_02(object,78      subobject,79      genprocid)80      SELECT81        x.uid,82        NULL,83        @GenProcID84      FROM(85      SELECT d.UID_ESet AS uid86      FROM deleted d87      JOIN ESetHasEntitlement dd88        ON d.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect,89      dd.XIsInEffect) = 190      UNION91      SELECT p.UID_ESet AS uid92      FROM deleted d93      JOIN ESetHasEntitlement dd94        ON d.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect,95      dd.XIsInEffect) = 196      JOIN Eset p97        ON d.Entitlement = p.XObjectKey98      UNION99      SELECT ehe.uid_ESet100      FROM deleted d101      JOIN ESetHasEntitlement dd102        ON d.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect,103      dd.XIsInEffect) = 1104      JOIN ESet p105        ON d.Entitlement = p.XObjectKey106      JOIN EsetHasEntitlement ehe107        ON ehe.Entitlement = p.XObjectKey) AS x108      IF @DebugSwitch > 0109      BEGIN110        SELECT @DebugMessage = OBJECT_NAME(@@procid) + ' stelle 2' print @DebugMessage111        SELECT *112        FROM deleted113        SELECT *114        FROM inserted115        SELECT *116        FROM @DBQueueElements_02117      END118      SELECT @UID_TaskFollow = 'RMS-K-ESetCollection'119      EXEC QBM_PDBQueueInsert_Bulk @UID_TaskFollow,120        @DBQueueElements_02121      DECLARE @DBQueueElements_03 QBM_YDBQueueRaw122      INSERT INTO @DBQueueElements_03(object,123      subobject,124      genprocid)125      SELECT126        x.uid,127        NULL,128        @GenProcID129      FROM(130      SELECT131        DISTINCT ec.UID_ESet AS uid132      FROM deleted d133      JOIN ESetHasEntitlement dd134        ON d.XObjectKey = dd.XObjectKey135      JOIN ESetCollection ec136        ON d.uid_ESet = ec.UID_EsetChild137      WHERE138        dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect, dd.XIsInEffect) = 1) AS x139      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement',140        @DBQueueElements_03141      DELETE @ElementBufferMulti142      INSERT INTO @ElementBufferMulti(UID1,143      Ident1)144      SELECT145        DISTINCT v.UID_TaskBaseTree,146        t.TableName147      FROM deleted i148      JOIN ESetHasEntitlement dd149        ON i.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin,150      dd.XOrigin,151      i.XIsInEffect,152      dd.XIsInEffect) = 1153      JOIN DialogTable t154        ON i.Entitlement LIKE '<Key><T>' + t.TableName + '</T>%'155      JOIN BaseTreeAssign v156        ON t.UID_DialogTable = v.UID_DialogTableElement157      WHERE158        v.UID_TaskBaseTree > ' '159      SELECT @ElementCount = @@ROWCOUNT160      SELECT @ElementIndex = @@IDENTITY - @ElementCount +1161      SELECT @ElementLast = @@IDENTITY162      WHILE @ElementIndex <= @ElementLast163      BEGIN164        SELECT165          TOP 1 @EsetOperation = bu.UID1,166          @EsetTable = bu.Ident1167        FROM @ElementBufferMulti bu168        WHERE169          bu.ElementIndex = @ElementIndex170        IF @DebugSwitch > 0171        BEGIN172          print '@EsetOperation ' + @EsetOperation+ ' -- ' + @EsetTable173        END174        DELETE @DBQueueElements_spezial175        INSERT INTO @DBQueueElements_spezial(object,176        subobject,177        genprocid)178        SELECT179          x.uid,180          NULL,181          @GenProcID182        FROM(183        SELECT184          DISTINCT ehe.uid_org AS uid185        FROM deleted i186        JOIN ESetHasEntitlement dd187          ON i.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect,188        dd.XIsInEffect) = 1189        JOIN BaseTreehaseset ehe190          ON i.uid_ESet = ehe.uid_ESet AND ehe.XOrigin > 0191        WHERE192          i.Entitlement LIKE '<Key><T>' + @EsetTable + '</T>%') AS x193        EXEC QBM_PDBQueueInsert_Bulk @EsetOperation,194          @DBQueueElements_spezial195        SELECT @ElementIndex += 1196      END197      DELETE @ElementBufferMulti198      INSERT INTO @ElementBufferMulti(UID1,199      Ident1)200      SELECT201        DISTINCT v.UID_TaskPerson,202        t.TableName203      FROM deleted i204      JOIN ESetHasEntitlement dd205        ON i.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin,206      dd.XOrigin,207      i.XIsInEffect,208      dd.XIsInEffect) = 1209      JOIN DialogTable t210        ON i.Entitlement LIKE '<Key><T>' + t.TableName + '</T>%'211      JOIN BaseTreeAssign v212        ON t.UID_DialogTable = v.UID_DialogTableElement213      WHERE214        v.UID_TaskPerson > ' '215      SELECT @ElementCount = @@ROWCOUNT216      SELECT @ElementIndex = @@IDENTITY - @ElementCount +1217      SELECT @ElementLast = @@IDENTITY218      WHILE @ElementIndex <= @ElementLast219      BEGIN220        SELECT221          TOP 1 @EsetOperation = bu.UID1,222          @EsetTable = bu.Ident1223        FROM @ElementBufferMulti bu224        WHERE225          bu.ElementIndex = @ElementIndex226        DELETE @DBQueueElements_spezial227        INSERT INTO @DBQueueElements_spezial(object,228        subobject,229        genprocid)230        SELECT231          x.uid,232          NULL,233          @GenProcID234        FROM(235        SELECT236          DISTINCT ehe.UID_Person AS uid237        FROM deleted i238        JOIN ESetHasEntitlement dd239          ON i.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect,240        dd.XIsInEffect) = 1241        JOIN PersonHasESet ehe242          ON i.uid_ESet = ehe.uid_ESet AND ehe.XOrigin > 0243        WHERE244          i.Entitlement LIKE '<Key><T>' + @EsetTable + '</T>%') AS x245        EXEC QBM_PDBQueueInsert_Bulk @EsetOperation,246          @DBQueueElements_spezial247        SELECT @ElementIndex += 1248      END249      DELETE @ElementBufferMulti250      INSERT INTO @ElementBufferMulti(UID1,251      Ident1)252      SELECT253        DISTINCT v.UID_TaskWorkDesk,254        t.TableName255      FROM deleted i256      JOIN ESetHasEntitlement dd257        ON i.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin,258      dd.XOrigin,259      i.XIsInEffect,260      dd.XIsInEffect) = 1261      JOIN DialogTable t262        ON i.Entitlement LIKE '<Key><T>' + t.TableName + '</T>%'263      JOIN BaseTreeAssign v264        ON t.UID_DialogTable = v.UID_DialogTableElement265      WHERE266        v.UID_TaskWorkDesk > ' '267      SELECT @ElementCount = @@ROWCOUNT268      SELECT @ElementIndex = @@IDENTITY - @ElementCount +1269      SELECT @ElementLast = @@IDENTITY270      WHILE @ElementIndex <= @ElementLast271      BEGIN272        SELECT273          TOP 1 @EsetOperation = bu.UID1,274          @EsetTable = bu.Ident1275        FROM @ElementBufferMulti bu276        WHERE277          bu.ElementIndex = @ElementIndex278        DELETE @DBQueueElements_spezial279        INSERT INTO @DBQueueElements_spezial(object,280        subobject,281        genprocid)282        SELECT283          x.uid,284          NULL,285          @GenProcID286        FROM(287        SELECT288          DISTINCT ehe.UID_WorkDesk AS uid289        FROM deleted i290        JOIN ESetHasEntitlement dd291          ON i.XObjectKey = dd.XObjectKey AND dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect,292        dd.XIsInEffect) = 1293        JOIN WorkDeskHasESet ehe294          ON i.uid_ESet = ehe.uid_ESet AND ehe.XOrigin > 0295        WHERE296          i.Entitlement LIKE '<Key><T>' + @EsetTable + '</T>%') AS x297        EXEC QBM_PDBQueueInsert_Bulk @EsetOperation,298          @DBQueueElements_spezial299        SELECT @ElementIndex += 1300      END301    END302  END TRY303  BEGIN CATCH304    EXEC QBM_PSessionErrorAdd DEFAULT305    RAISERROR('',306    18,307    1)308      WITH NOWAIT309  END CATCH310  ende:311  RETURN312END
Open raw exported source
SQL ยท Raw51 lines
1create   trigger RMS_TUESetHasEntitlement on ESetHasEntitlement  for update not for Replication as begin declare @EsetOperation varchar(38) declare2 @EsetTable varchar(30) declare @DebugSwitch int = 0 declare @DebugMessage nvarchar(max) declare @ElementLast int declare @ElementBufferMulti QBM_YCursorBuffer3 declare @ElementCount int declare @ElementIndex int declare @QBM_BitPatternXOrigin_Direct int = dbo.QBM_FGIBitPatternXOrigin('|Direct|', 0) declare @DBQueueElements_spezial4 QBM_YDBQueueRaw declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() declare @UID_TaskFollow varchar(38) BEGIN TRY5 if exists (select top 1 1 from deleted) goto start if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select6 @GenProcID = dbo.QBM_FGISessionContext('') if update(XOrigin) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object7, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct d.UID_ESet as uid from deleted d join ESetHasEntitlement dd on d.XObjectKey8 = dd.XObjectKey where dbo.QBM_FGIXOriginChanged_Except2(d.XOrigin, dd.XOrigin ) = 1  ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement', @DBQueueElements_019 end   if update(XOrigin) and not update(XIsInEffect) begin update ESetHasEntitlement set XIsInEffect = 1  , XDateUpdated = @Xdate , XUserUpdated = @XUser10 from ESetHasEntitlement ehe join deleted d on ehe.UID_ESetHasEntitlement = d.UID_ESetHasEntitlement where d.XOrigin = 0 and ehe.XOrigin & @QBM_BitPatternXOrigin_Direct11 > 0 and ehe.Entitlement not like '<Key><T>ESet</T>%' end if update(XIsInEffect) or update(XOrigin) begin if @DebugSwitch > 0 begin select @DebugMessage12 = OBJECT_NAME(@@procid) + ' stelle 1' print @DebugMessage end  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject13, genprocid) select x.uid, null, @GenProcID from ( select d.UID_ESet as uid from deleted d join ESetHasEntitlement dd on d.XObjectKey = dd.XObjectKey and14 dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect, dd.XIsInEffect) = 1 union select p.UID_ESet as uid from deleted d join ESetHasEntitlement15 dd on d.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect, dd.XIsInEffect) = 1 join Eset p on d.Entitlement16 = p.XObjectKey union select ehe.uid_ESet from deleted d join ESetHasEntitlement dd on d.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect17(d.XOrigin, dd.XOrigin, d.XIsInEffect, dd.XIsInEffect) = 1 join ESet p on d.Entitlement = p.XObjectKey join EsetHasEntitlement ehe on ehe.Entitlement =18 p.XObjectKey ) as x if @DebugSwitch > 0 begin select @DebugMessage = OBJECT_NAME(@@procid) + ' stelle 2' print @DebugMessage select * from deleted select19 * from inserted select * from @DBQueueElements_02 end  select @UID_TaskFollow = 'RMS-K-ESetCollection' exec QBM_PDBQueueInsert_Bulk @UID_TaskFollow, @DBQueueElements_0220  declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select21 distinct ec.UID_ESet as uid from deleted d join ESetHasEntitlement dd on d.XObjectKey = dd.XObjectKey join ESetCollection ec on d.uid_ESet = ec.UID_EsetChild22 where dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, dd.XOrigin, d.XIsInEffect, dd.XIsInEffect) = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement'23, @DBQueueElements_03  delete  @ElementBufferMulti insert into @ElementBufferMulti(UID1, Ident1) select distinct v.UID_TaskBaseTree, t.TableName from deleted24 i join ESetHasEntitlement dd on i.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect, dd.XIsInEffect25) = 1 join DialogTable t on  i.Entitlement like '<Key><T>' + t.TableName + '</T>%' join BaseTreeAssign v on t.UID_DialogTable = v.UID_DialogTableElement26 where v.UID_TaskBaseTree > ' ' select @ElementCount = @@ROWCOUNT select @ElementIndex = @@IDENTITY - @ElementCount +1 select @ElementLast = @@IDENTITY27 while @ElementIndex <= @ElementLast begin select top 1 @EsetOperation = bu.UID1 , @EsetTable = bu.Ident1 from @ElementBufferMulti bu where bu.ElementIndex28 = @ElementIndex if @DebugSwitch > 0 begin print '@EsetOperation ' + @EsetOperation+ ' -- ' + @EsetTable end  delete  @DBQueueElements_spezial insert into29 @DBQueueElements_spezial (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ehe.uid_org as uid from deleted i join ESetHasEntitlement30 dd on i.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect, dd.XIsInEffect) = 1 join BaseTreehaseset31 ehe on i.uid_ESet = ehe.uid_ESet and ehe.XOrigin > 0  where  i.Entitlement like '<Key><T>' + @EsetTable + '</T>%' ) as x exec QBM_PDBQueueInsert_Bulk 32@EsetOperation, @DBQueueElements_spezial select @ElementIndex += 1 end   delete  @ElementBufferMulti insert into @ElementBufferMulti(UID1, Ident1) select33 distinct v.UID_TaskPerson, t.TableName from deleted i join ESetHasEntitlement dd on i.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin34, dd.XOrigin, i.XIsInEffect, dd.XIsInEffect) = 1 join DialogTable t on  i.Entitlement like '<Key><T>' + t.TableName + '</T>%' join BaseTreeAssign v on 35t.UID_DialogTable = v.UID_DialogTableElement where v.UID_TaskPerson > ' ' select @ElementCount = @@ROWCOUNT select @ElementIndex = @@IDENTITY - @ElementCount36 +1 select @ElementLast = @@IDENTITY while @ElementIndex <= @ElementLast begin select top 1 @EsetOperation = bu.UID1 , @EsetTable = bu.Ident1 from @ElementBufferMulti37 bu where bu.ElementIndex = @ElementIndex   delete  @DBQueueElements_spezial insert into @DBQueueElements_spezial (object, subobject, genprocid) select38 x.uid, null, @GenProcID from ( select distinct ehe.UID_Person as uid from deleted i join ESetHasEntitlement dd on i.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect39(i.XOrigin, dd.XOrigin, i.XIsInEffect, dd.XIsInEffect) = 1 join PersonHasESet ehe on i.uid_ESet = ehe.uid_ESet and ehe.XOrigin > 0  where  i.Entitlement40 like '<Key><T>' + @EsetTable + '</T>%' ) as x exec QBM_PDBQueueInsert_Bulk @EsetOperation, @DBQueueElements_spezial select @ElementIndex += 1 end   delete41  @ElementBufferMulti insert into @ElementBufferMulti(UID1, Ident1) select distinct v.UID_TaskWorkDesk, t.TableName from deleted i join ESetHasEntitlement42 dd on i.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect, dd.XIsInEffect) = 1 join DialogTable t on43  i.Entitlement like '<Key><T>' + t.TableName + '</T>%' join BaseTreeAssign v on t.UID_DialogTable = v.UID_DialogTableElement where v.UID_TaskWorkDesk 44> ' ' select @ElementCount = @@ROWCOUNT select @ElementIndex = @@IDENTITY - @ElementCount +1 select @ElementLast = @@IDENTITY while @ElementIndex <= @ElementLast45 begin select top 1 @EsetOperation = bu.UID1 , @EsetTable = bu.Ident1 from @ElementBufferMulti bu where bu.ElementIndex = @ElementIndex   delete  @DBQueueElements_spezial46 insert into @DBQueueElements_spezial (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ehe.UID_WorkDesk as uid from47 deleted i join ESetHasEntitlement dd on i.XObjectKey = dd.XObjectKey and dbo.QBM_FGIXOriginChanged_Effect(i.XOrigin, dd.XOrigin, i.XIsInEffect, dd.XIsInEffect48) = 1 join WorkDeskHasESet ehe on i.uid_ESet = ehe.uid_ESet and ehe.XOrigin > 0  where  i.Entitlement like '<Key><T>' + @EsetTable + '</T>%' ) as x exec49 QBM_PDBQueueInsert_Bulk @EsetOperation, @DBQueueElements_spezial select @ElementIndex += 1 end  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default50 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 51