Back to OIM Explorer

dbo.TSB_RUNSAccountBHasUNSItemB

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 2.058 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.DPR_FGIProjectionRootRunning source text reference
  • references source dbo.DPR_PSlotResetWhileProj_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSlotResetOnMissingItem_L source text reference
  • references source dbo.QBM_PSlotResetWhileJobRun_L source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL95 lines
1CREATE PROCEDURE TSB_RUNSAccountBHasUNSItemB(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @ObjectKeysToCheck_Projection QBM_YParameterList7  DECLARE @ObjectKeysToCheck_Jobrunning QBM_YParameterList8  DECLARE @MyName nvarchar(64) = object_name(@@procid)9  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent10  DECLARE @resetted int11  BEGIN TRY12    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,13    UID_Parameter,14    UID_SubParameter,15    GenProcID)16    SELECT17      UID_DialogDBQueue,18      UID_Parameter,19      UID_SubParameter,20      GenProcID21    FROM QBMDBQueueCurrent cu22      WITH(readpast)23    WHERE24      cu.SlotNumber = @SlotNumber25    IF @@rowcount = 026    BEGIN27      GOTO EndLabel28    END29    EXEC @resetted = QBM_PSlotResetOnMissingItem_L @DBQueueCurrent,30    'UNSAccountB',31    'UID_UNSAccountB',32      @SlotNumber33    IF @resetted > 034    BEGIN35      DELETE @DBQueueCurrent36      FROM @DBQueueCurrent v37      LEFT38      OUTER39      JOIN QBMDBQueueCurrent cu40        WITH(readpast)41        ON v.UID_DialogDBQueue = cu.UID_DialogDBQueue AND cu.SlotNumber = @SlotNumber42      WHERE43        cu.UID_DialogDBQueue IS NULL44    END45    IF 1 = dbo.DPR_FGIProjectionRootRunning('UnsRootB')46    BEGIN47      INSERT INTO @ObjectKeysToCheck_Projection(Parameter1,48      Parameter2)49      SELECT50        cu.UID_Parameter,51        ro.XObjectKey52      FROM @DBQueueCurrent cu53      JOIN UNSAccountB x54        ON cu.UID_Parameter = x.UID_UNSAccountB55      JOIN UNSRootB ro56        ON x.UID_UNSRootB = ro.UID_UNSRootB57      EXEC @resetted = DPR_PSlotResetWhileProj_L @DBQueueCurrent,58        @ObjectKeysToCheck_Projection,59        @MyName,60        @SlotNumber61      IF @resetted > 062      BEGIN63        DELETE @DBQueueCurrent64        FROM @DBQueueCurrent v65        LEFT66        OUTER67        JOIN QBMDBQueueCurrent cu68          WITH(readpast)69          ON v.UID_DialogDBQueue = cu.UID_DialogDBQueue AND cu.SlotNumber = @SlotNumber70        WHERE71          cu.UID_DialogDBQueue IS NULL72      END73    END74    INSERT INTO @ObjectKeysToCheck_Jobrunning(Parameter1,75    Parameter2)76    SELECT77      cu.UID_Parameter,78      x.XObjectKey79    FROM @DBQueueCurrent cu80    JOIN UNSAccountB x81      ON cu.UID_Parameter = x.UID_UNSAccountB82    EXEC @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent,83      @@PROCID,84      @ObjectKeysToCheck_Jobrunning,85      @SlotNumber = @SlotNumber86  END TRY87  BEGIN CATCH88    EXEC QBM_PSessionErrorAdd DEFAULT89    RAISERROR('',90    18,91    1)92      WITH NOWAIT93  END CATCH94  endLabel:95END
Open raw exported source
SQL ยท Raw14 lines
1create   procedure TSB_RUNSAccountBHasUNSItemB (@SlotNumber int) AS begin declare @ObjectKeysToCheck_Projection QBM_YParameterList declare @ObjectKeysToCheck_Jobrunning2 QBM_YParameterList declare @MyName nvarchar(64) = object_name(@@procid) declare @DBQueueCurrent QBM_YDBQueueCurrent declare @resetted int BEGIN TRY insert3 into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID4 from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  exec @resetted = QBM_PSlotResetOnMissingItem_L5 @DBQueueCurrent, 'UNSAccountB', 'UID_UNSAccountB', @SlotNumber if @resetted > 0 begin delete  @DBQueueCurrent from @DBQueueCurrent v left outer join QBMDBQueueCurrent6 cu with (readpast) on v.UID_DialogDBQueue = cu.UID_DialogDBQueue and cu.SlotNumber = @SlotNumber where cu.UID_DialogDBQueue is null end if 1 = dbo.DPR_FGIProjectionRootRunning7 ('UnsRootB') begin insert into @ObjectKeysToCheck_Projection(Parameter1, Parameter2) select cu.UID_Parameter, ro.XObjectKey from @DBQueueCurrent cu join8 UNSAccountB x on cu.UID_Parameter = x.UID_UNSAccountB join UNSRootB ro on x.UID_UNSRootB = ro.UID_UNSRootB exec @resetted = DPR_PSlotResetWhileProj_L 9@DBQueueCurrent, @ObjectKeysToCheck_Projection, @MyName, @SlotNumber if @resetted > 0 begin delete  @DBQueueCurrent from @DBQueueCurrent v left outer join10 QBMDBQueueCurrent cu with (readpast) on v.UID_DialogDBQueue = cu.UID_DialogDBQueue and cu.SlotNumber = @SlotNumber where cu.UID_DialogDBQueue is null 11end end  insert into @ObjectKeysToCheck_Jobrunning(Parameter1, Parameter2) select cu.UID_Parameter, x.XObjectKey from @DBQueueCurrent cu join UNSAccountB12 x on cu.UID_Parameter = x.UID_UNSAccountB exec @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning, @SlotNumber13 = @SlotNumber  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 14