Back to OIM Explorer

dbo.QER_RDynamicGroupTest

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.107 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_FCVElementToObjectKey1 source text reference
  • 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

SQL52 lines
1CREATE PROCEDURE QER_RDynamicGroupTest(2  @SlotNumber int,3  @UID_DynamicGroup varchar(38),4  @SubObject varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ObjectKeysToCheck_Projection QBM_YParameterList10  DECLARE @ObjectKeysToCheck_Jobrunning QBM_YParameterList11  DECLARE @MyName nvarchar(64) = object_name(@@procid)12  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent13  DECLARE @resetted int14  BEGIN TRY15    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,16    UID_Parameter,17    UID_SubParameter,18    GenProcID)19    SELECT20      UID_DialogDBQueue,21      UID_Parameter,22      UID_SubParameter,23      GenProcID24    FROM QBMDBQueueCurrent cu25      WITH(readpast)26    WHERE27      cu.SlotNumber = @SlotNumber28    IF @@rowcount = 029    BEGIN30      GOTO EndLabel31    END32    INSERT INTO @ObjectKeysToCheck_Jobrunning(Parameter1,33    Parameter2)34    SELECT35      @UID_DynamicGroup,36      dbo.QBM_FCVElementToObjectKey1('DynamicGroup',37      'UID_DynamicGroup',38      @UID_DynamicGroup)39    EXEC @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent,40      @@PROCID,41      @ObjectKeysToCheck_Jobrunning,42      @SlotNumber = @SlotNumber43  END TRY44  BEGIN CATCH45    EXEC QBM_PSessionErrorAdd DEFAULT46    RAISERROR('',47    18,48    1)49      WITH NOWAIT50  END CATCH51  endLabel:52END
Open raw exported source
SQL ยท Raw8 lines
1create   procedure QER_RDynamicGroupTest (@SlotNumber int , @UID_DynamicGroup varchar(38) , @SubObject varchar(38) , @GenProcID varchar(38) ) AS2 begin declare @ObjectKeysToCheck_Projection QBM_YParameterList declare @ObjectKeysToCheck_Jobrunning QBM_YParameterList declare @MyName nvarchar(64) =3 object_name(@@procid) declare @DBQueueCurrent QBM_YDBQueueCurrent declare @resetted int BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter4, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber5 = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  insert into @ObjectKeysToCheck_Jobrunning(Parameter1, Parameter2) select @UID_DynamicGroup, dbo.QBM_FCVElementToObjectKey16('DynamicGroup', 'UID_DynamicGroup', @UID_DynamicGroup) exec @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning7, @SlotNumber = @SlotNumber  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 8