Back to OIM Explorer

dbo.QER_RAllForPersonInBaseTree

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.138 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.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSlotResetWhileJobRun_L source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL53 lines
1CREATE PROCEDURE QER_RAllForPersonInBaseTree(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    INSERT INTO @ObjectKeysToCheck_Jobrunning(Parameter1,30    Parameter2,31    Parameter3)32    SELECT33      cu.UID_Parameter,34      x.XObjectKey,35      cu.UID_SubParameter36    FROM @DBQueueCurrent cu37    JOIN PersonInBaseTree x38      ON cu.UID_Parameter = x.UID_Person AND cu.UID_SubParameter = x.UID_Org39    EXEC @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent,40      @@PROCID,41      @ObjectKeysToCheck_Jobrunning,42      @CountParameterOfTask = 2,43      @SlotNumber = @SlotNumber44  END TRY45  BEGIN CATCH46    EXEC QBM_PSessionErrorAdd DEFAULT47    RAISERROR('',48    18,49    1)50      WITH NOWAIT51  END CATCH52  endLabel:53END
Open raw exported source
SQL ยท Raw9 lines
1create   procedure QER_RAllForPersonInBaseTree (@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  insert into @ObjectKeysToCheck_Jobrunning5(Parameter1, Parameter2, Parameter3) select cu.UID_Parameter, x.XObjectKey, cu.UID_SubParameter from @DBQueueCurrent cu join PersonInBaseTree x on cu.UID_Parameter6 = x.UID_Person and cu.UID_SubParameter = x.UID_Org exec @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning7 , @CountParameterOfTask = 2, @SlotNumber = @SlotNumber  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH8 endLabel: end 9