Back to OIM Explorer

dbo.RMS_ZESetCollection

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> RMS-K-ESetCollection / RMS_ZESetCollection at line 28; Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 28; Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 28; Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 28

Source: sandbox-db sys.sql_modules

Source size: 6.123 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> RMS-K-ESetCollection / RMS_ZESetCollection at line 28
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 28
  • Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 28
  • Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 28
  • Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 28
  • Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 30
  • Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 30
  • Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 30
  • Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 30
  • Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 33
  • Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 33
  • Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 33
  • Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 35
  • Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 35
  • Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 38
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task RMS_ZESetCollection at line 28 Bulk DBQueue insert -> RMS-K-ESetCollection / RMS_ZESetCollection at line 28
  • queues DBQueue task RMS_ZESetHasEntitlement at line 28 Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 28
  • queues DBQueue task RMS_ZOrgHasESet at line 28 Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 28
  • queues DBQueue task RMS_ZPersonHasESet at line 28 Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 28
  • queues DBQueue task RMS_ZWorkDeskHasESet at line 28 Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 28
  • queues DBQueue task RMS_ZESetHasEntitlement at line 30 Bulk DBQueue insert -> RMS-K-ESetHasEntitlement / RMS_ZESetHasEntitlement at line 30
  • queues DBQueue task RMS_ZOrgHasESet at line 30 Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 30
  • queues DBQueue task RMS_ZPersonHasESet at line 30 Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 30
  • queues DBQueue task RMS_ZWorkDeskHasESet at line 30 Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 30
  • queues DBQueue task RMS_ZOrgHasESet at line 33 Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 33
  • queues DBQueue task RMS_ZPersonHasESet at line 33 Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 33
  • queues DBQueue task RMS_ZWorkDeskHasESet at line 33 Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 33
  • queues DBQueue task RMS_ZPersonHasESet at line 35 Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 35
  • queues DBQueue task RMS_ZWorkDeskHasESet at line 35 Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 35
  • queues DBQueue task RMS_ZWorkDeskHasESet at line 38 Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 38
  • references source dbo.QBM_FGIBitPatternXOrigin source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueCalculateDelta source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task RMS-K-ESetCollection -> RMS_ZESetCollection QBM_PDBQueueInsert_Bulk 'RMS-K-ESetCollection', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select d.Element as uid, …
  • queues DBQueue task RMS-K-ESetHasEntitlement -> RMS_ZESetHasEntitlement QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct co.ui…
  • queues DBQueue task RMS-K-OrgHasESet -> RMS_ZOrgHasESet QBM_PDBQueueInsert_Bulk 'RMS-K-OrgHasESet', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct phe.uid_Perso…
  • queues DBQueue task RMS-K-PersonHasESet -> RMS_ZPersonHasESet QBM_PDBQueueInsert_Bulk 'RMS-K-PersonHasESet', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct whe.uid_Wo…
  • queues DBQueue task RMS-K-WorkdeskHasESet -> RMS_ZWorkDeskHasESet QBM_PDBQueueInsert_Bulk 'RMS-K-WorkdeskHasESet', @DBQueueElements_05 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R retu…

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL275 lines
1CREATE PROCEDURE RMS_ZESetCollection(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @Sourcedata QBM_YDataForDelta,7  @CountDeltaQantity int,8  @CountDeltaOrigin int9  DECLARE @AnzahlRow int10  DECLARE @GenProcID varchar(38)11  DECLARE @DebugSwitch int = 012  DECLARE @DebugMessage nvarchar(max)13  DECLARE @ElementCount int14  DECLARE @ElementIndex int15  DECLARE @ElementLast int16  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')17  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent18  DECLARE @QBM_BitPatternXOrigin_Inherit int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|',19  0)20  DECLARE @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|',21  1)22  BEGIN TRY23    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,24    UID_Parameter,25    UID_SubParameter,26    GenProcID)27    SELECT28      UID_DialogDBQueue,29      UID_Parameter,30      UID_SubParameter,31      GenProcID32    FROM QBMDBQueueCurrent cu33      WITH(readpast)34    WHERE35      cu.SlotNumber = @SlotNumber36    IF @@rowcount = 037    BEGIN38      GOTO EndLabel39    END40    SELECT TOP 1 @GenProcID = GenProcID41    FROM @DBQueueCurrent p42    INSERT INTO @SourceData(IsUpcommingContent,43    XOriginAfter,44    Element,45    AssignedElement,46    XOriginBefore)47    SELECT48      0,49      0,50      ec.UID_ESet,51      ec.UID_EsetChild,52      @QBM_BitPatternXOrigin_Inherit53    FROM ESetCollection ec54    JOIN @DBQueueCurrent p55      ON ec.UID_ESet = p.UID_Parameter56    INSERT INTO @SourceData(IsUpcommingContent,57    XOriginBefore,58    Element,59    AssignedElement,60    XOriginAfter)61    SELECT62      1,63      0,64      es.UID_ESet,65      es.UID_ESet,66      @QBM_BitPatternXOrigin_Inherit67    FROM ESet es68    JOIN @DBQueueCurrent p69      ON es.UID_ESet = p.UID_Parameter zyklus:70    SELECT @AnzahlRow = 171    WHILE @AnzahlRow > 072    BEGIN73      SELECT @AnzahlRow = 074      INSERT INTO @SourceData(IsUpcommingContent,75      XOriginBefore,76      Element,77      AssignedElement,78      XOriginAfter)79      SELECT80        DISTINCT 1,81        0,82        y.Element,83        p.uid_ESet AS UID_EsetChild,84        @QBM_BitPatternXOrigin_Inherit85      FROM @SourceData y86      JOIN ESet e87        ON y.Element = e.UID_ESet AND e.IsInActive = 0 AND y.IsUpcommingContent = 188      JOIN ESetHasEntitlement ehe89        ON y.AssignedElement = ehe.uid_ESet AND ehe.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv> 090      JOIN ESet p91        ON p.XObjectKey = ehe.entitlement AND p.IsInActive = 092      WHERE93        NOT EXISTS(94      SELECT TOP 1 195      FROM @SourceData96      WHERE97        Element = y.Element AND AssignedElement = p.uid_ESet AND IsUpcommingContent = 1)98      SELECT @AnzahlRow = @AnzahlRow + @@rowcount99    END100    EXEC QBM_PDBQueueCalculateDelta @SourceData,101      @DeltaQuantity = 1,102      @DeltaDelete = 1,103      @DeltaInsert = 1,104      @DeltaOrigin = 0,105      @CountDeltaQantity = @CountDeltaQantity OUTPUT,106      @CountDeltaOrigin = @CountDeltaOrigin OUTPUT,107      @UseIsInEffect = 0,108      @SlotNumber = @SlotNumber,109      @DBQueueCurrentExtern = @DBQueueCurrent110    IF @CountDeltaQantity > 0111    BEGIN112      IF @DebugSwitch > 0113      BEGIN114        SELECT115          @DebugMessage = object_name(@@procid) + '@CountDeltaQantity > 0 gefunden ' print @DebugMessage116      END117      DECLARE @GenProcIDs_CountDeltaQuantity QBM_YCursorBuffer118      INSERT INTO @GenProcIDs_CountDeltaQuantity(UID1)119      SELECT de.GenProcID120      FROM #QBMDeltaDelete de121      UNION122      SELECT de.GenProcID123      FROM #QBMDeltaInsert de124      SELECT @ElementCount = @@ROWCOUNT125      SELECT @ElementIndex = @@IDENTITY - @ElementCount +1126      SELECT @ElementLast = @@IDENTITY127      WHILE @ElementIndex <= @ElementLast128      BEGIN129        SELECT TOP 1 @GenProcID = bu.UID1130        FROM @GenProcIDs_CountDeltaQuantity bu131        WHERE132          bu.ElementIndex = @ElementIndex133        IF EXISTS(134          SELECT TOP 1 1135          FROM #QBMDeltaDelete x136          WHERE137            x.GenProcID = @GenProcID)138        BEGIN139          EXEC QBM_PSessionContextSet 'GenProcID',140            @GenProcID141          DELETE142          FROM ESetCollection143          WHERE144            EXISTS(145          SELECT TOP 1 1146          FROM #QBMDeltaDelete d147          WHERE148            d.Element = ESetCollection.uid_ESet AND d.AssignedElement = ESetCollection.UID_EsetChild AND d.GenProcID = @GenProcID)149        END150        IF EXISTS(151          SELECT TOP 1 1152          FROM #QBMDeltaInsert x153          WHERE154            x.GenProcID = @GenProcID)155        BEGIN156          EXEC QBM_PSessionContextSet 'GenProcID',157            @GenProcID158          INSERT INTO ESetCollection(UID_Eset,159          UID_EsetChild)160          SELECT161            Element,162            AssignedElement163          FROM #QBMDeltaInsert164          WHERE165            GenProcID = @GenProcID166        END167        SELECT @ElementIndex += 1168      END169      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw170      INSERT INTO @DBQueueElements_01(object,171      subobject,172      genprocid)173      SELECT174        x.uid,175        NULL,176        x.GenProcID177      FROM(178      SELECT179        DISTINCT ehe.uid_Eset AS uid,180        d.GenProcID AS GenProcID181      FROM ESetHasEntitlement ehe182      JOIN ESet p183        ON p.XObjectKey = ehe.entitlement AND ehe.XOrigin > 0184      JOIN #QBMDeltaQuantity d185        ON p.uid_ESet = d.Element186      WHERE187        ehe.XIsInEffect = 1) AS x188      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-ESetCollection',189        @DBQueueElements_01190      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw191      INSERT INTO @DBQueueElements_02(object,192      subobject,193      genprocid)194      SELECT195        x.uid,196        NULL,197        x.GenProcID198      FROM(199      SELECT200        d.Element AS uid,201        d.GenProcID AS GenProcID202      FROM #QBMDeltaQuantity d) AS x203      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement',204        @DBQueueElements_02205      DECLARE @DBQueueElements_03 QBM_YDBQueueRaw206      INSERT INTO @DBQueueElements_03(object,207      subobject,208      genprocid)209      SELECT210        x.uid,211        NULL,212        x.GenProcID213      FROM(214      SELECT215        DISTINCT co.uid_org AS uid,216        d.GenProcID AS GenProcID217      FROM BaseTreeHasESet bhe218      JOIN BaseTreecollection co219        ON bhe.uid_Org = co.uid_parentOrg AND bhe.XOrigin > 0220      JOIN #QBMDeltaQuantity d221        ON bhe.uid_ESet = d.Element) AS x222      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-OrgHasESet',223        @DBQueueElements_03224      DECLARE @DBQueueElements_04 QBM_YDBQueueRaw225      INSERT INTO @DBQueueElements_04(object,226      subobject,227      genprocid)228      SELECT229        x.uid,230        NULL,231        x.GenProcID232      FROM(233      SELECT234        DISTINCT phe.uid_Person AS uid,235        d.GenProcID AS GenProcID236      FROM PersonHasESet phe237      JOIN #QBMDeltaQuantity d238        ON phe.uid_ESet = d.Element239      WHERE240        phe.XOrigin > 0) AS x241      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-PersonHasESet',242        @DBQueueElements_04243      DECLARE @DBQueueElements_05 QBM_YDBQueueRaw244      INSERT INTO @DBQueueElements_05(object,245      subobject,246      genprocid)247      SELECT248        x.uid,249        NULL,250        x.GenProcID251      FROM(252      SELECT253        DISTINCT whe.uid_WorkDesk AS uid,254        d.GenProcID AS GenProcID255      FROM WorkDeskHasESet whe256      JOIN #QBMDeltaQuantity d257        ON whe.uid_ESet = d.Element258      WHERE259        whe.XOrigin > 0) AS x260      EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-WorkdeskHasESet',261        @DBQueueElements_05262    END263  END TRY264  BEGIN CATCH265    EXEC QBM_PSessionErrorAdd DEFAULT266    RAISERROR('',267    18,268    1)269      WITH NOWAIT270  END CATCH271  endLabel:272  EXEC QBM_PSessionContextSet 'GenProcID',273    @GenProcID_R274  RETURN275END
Open raw exported source
SQL · Raw40 lines
1        create   procedure RMS_ZESetCollection (@SlotNumber int)      AS begin declare @Sourcedata QBM_YDataForDelta , @CountDeltaQantity int , 2@CountDeltaOrigin int declare @AnzahlRow int declare @GenProcID varchar(38) declare @DebugSwitch int = 0 declare @DebugMessage nvarchar(max) declare @ElementCount3 int declare @ElementIndex int declare @ElementLast int declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @DBQueueCurrent QBM_YDBQueueCurrent4 declare @QBM_BitPatternXOrigin_Inherit int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|', 0) declare @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin5('|Inherit|', 1)  BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter6, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  select7 top 1 @GenProcID = GenProcID from @DBQueueCurrent p insert into @SourceData( IsUpcommingContent, XOriginAfter , Element, AssignedElement, XOriginBefore8 ) select 0, 0 , ec.UID_ESet, ec.UID_EsetChild , @QBM_BitPatternXOrigin_Inherit from ESetCollection ec join @DBQueueCurrent p on ec.UID_ESet = p.UID_Parameter9 insert into @SourceData( IsUpcommingContent, XOriginBefore , Element, AssignedElement, XOriginAfter ) select 1, 0 , es.UID_ESet, es.UID_ESet , @QBM_BitPatternXOrigin_Inherit10 from ESet es join @DBQueueCurrent p on es.UID_ESet = p.UID_Parameter  zyklus: select @AnzahlRow = 1 while @AnzahlRow > 0 begin select @AnzahlRow = 0  11insert into @SourceData( IsUpcommingContent, XOriginBefore , Element, AssignedElement, XOriginAfter ) select distinct 1, 0 , y.Element, p.uid_ESet as UID_EsetChild12 , @QBM_BitPatternXOrigin_Inherit  from @SourceData y join ESet e on y.Element = e.UID_ESet and e.IsInActive = 0 and y.IsUpcommingContent = 1 join ESetHasEntitlement13 ehe on y.AssignedElement = ehe.uid_ESet  and ehe.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv> 0  join ESet p on p.XObjectKey = ehe.entitlement and p.IsInActive14 = 0 where Not exists (select top 1 1  from @SourceData where Element = y.Element and AssignedElement = p.uid_ESet and IsUpcommingContent = 1 ) select 15@AnzahlRow = @AnzahlRow + @@rowcount end  exec QBM_PDBQueueCalculateDelta @SourceData, @DeltaQuantity = 1, @DeltaDelete = 1, @DeltaInsert = 1, @DeltaOrigin16 = 0, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin output , @UseIsInEffect = 0 , @SlotNumber = @SlotNumber , 17@DBQueueCurrentExtern = @DBQueueCurrent if @CountDeltaQantity > 0 begin if @DebugSwitch > 0 begin select @DebugMessage = object_name(@@procid) + '@CountDeltaQantity > 0 gefunden '18 print @DebugMessage end declare @GenProcIDs_CountDeltaQuantity QBM_YCursorBuffer insert into @GenProcIDs_CountDeltaQuantity (UID1) select de.GenProcID19 from #QBMDeltaDelete de union select de.GenProcID from #QBMDeltaInsert de select @ElementCount = @@ROWCOUNT select @ElementIndex = @@IDENTITY - @ElementCount20 +1 select @ElementLast = @@IDENTITY while @ElementIndex <= @ElementLast begin select top 1 @GenProcID = bu.UID1 from @GenProcIDs_CountDeltaQuantity bu21 where bu.ElementIndex = @ElementIndex if exists (select top 1 1 from #QBMDeltaDelete x where x.GenProcID = @GenProcID ) begin exec QBM_PSessionContextSet22 'GenProcID', @GenProcID delete from ESetCollection where exists (select top 1 1 from #QBMDeltaDelete d where d.Element = ESetCollection.uid_ESet and d.AssignedElement23 = ESetCollection.UID_EsetChild and d.GenProcID = @GenProcID ) end  if exists (select top 1 1 from #QBMDeltaInsert x where x.GenProcID = @GenProcID ) begin24 exec QBM_PSessionContextSet 'GenProcID', @GenProcID insert into ESetCollection (UID_Eset, UID_EsetChild) select Element, AssignedElement from #QBMDeltaInsert25 where GenProcID = @GenProcID end  select @ElementIndex += 1 end   declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object,26 subobject, genprocid) select x.uid, null, x.GenProcID from (  select distinct ehe.uid_Eset as uid, d.GenProcID as GenProcID from ESetHasEntitlement ehe27 join ESet p on p.XObjectKey = ehe.entitlement and ehe.XOrigin > 0  join #QBMDeltaQuantity d on p.uid_ESet = d.Element where ehe.XIsInEffect = 1 ) as x28 exec QBM_PDBQueueInsert_Bulk 'RMS-K-ESetCollection', @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 29(object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select d.Element as uid, d.GenProcID as GenProcID from #QBMDeltaQuantity d ) as x30 exec QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement', @DBQueueElements_02  declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_0331 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct co.uid_org as uid, d.GenProcID as GenProcID from BaseTreeHasESet32 bhe join BaseTreecollection co on bhe.uid_Org = co.uid_parentOrg and bhe.XOrigin > 0  join #QBMDeltaQuantity d on bhe.uid_ESet = d.Element ) as x exec33 QBM_PDBQueueInsert_Bulk 'RMS-K-OrgHasESet', @DBQueueElements_03  declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, 34subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct phe.uid_Person as uid, d.GenProcID as GenProcID from PersonHasESet phe join35 #QBMDeltaQuantity d on phe.uid_ESet = d.Element where phe.XOrigin > 0  ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-PersonHasESet', @DBQueueElements_04 36 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select37 distinct whe.uid_WorkDesk as uid, d.GenProcID as GenProcID from WorkDeskHasESet whe join #QBMDeltaQuantity d on whe.uid_ESet = d.Element where whe.XOrigin38 > 0  ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-WorkdeskHasESet', @DBQueueElements_05 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR39 ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end 40