Back to OIM Explorer

dbo.QER_ZDynamicGroupMakeProc

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 826 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.QER_PDynamicGroupMakeProc_Drop source text reference
  • references source dbo.QER_PDynamicGroupMakeProc_hlp source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL46 lines
1CREATE PROCEDURE QER_ZDynamicGroupMakeProc(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @UID_DynamicGroup varchar(38)7  DECLARE @Groups QBM_YSingleGUID8  SET XACT_ABORT OFF9  BEGIN TRY10    INSERT INTO @Groups(UID_SingleGuid)11    SELECT UID_Parameter12    FROM QBMDBQueueCurrent p13      WITH(readpast)14    WHERE15      p.SlotNumber = @SlotNumber16    WHILE(EXISTS(17    SELECT TOP 1 118    FROM @Groups))19    BEGIN20      SELECT TOP 1 @UID_DynamicGroup = g.UID_SingleGuid21      FROM @Groups g22      IF EXISTS(23        SELECT TOP 1 124        FROM DynamicGroup25        WHERE26          UID_DynamicGroup = @UID_DynamicGroup)27      BEGIN28        EXEC QER_PDynamicGroupMakeProc_hlp @UID_DynamicGroup29      END30      ELSE31      BEGIN32        EXEC QER_PDynamicGroupMakeProc_Drop @UID_DynamicGroup33      END34      DELETE @Groups35      WHERE36        UID_SingleGuid = @UID_DynamicGroup37    END38  END TRY39  BEGIN CATCH40    EXEC QBM_PSessionErrorAdd DEFAULT41    RAISERROR('',42    18,43    1)44      WITH NOWAIT45  END CATCH46END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure QER_ZDynamicGroupMakeProc (@SlotNumber int) as begin    declare @UID_DynamicGroup varchar(38) declare @Groups QBM_YSingleGUID2  SET XACT_ABORT OFF BEGIN TRY insert into @Groups(UID_SingleGuid ) select UID_Parameter from QBMDBQueueCurrent p with (readpast) where p.SlotNumber = 3@SlotNumber while (exists (select top 1 1 from @Groups)) BEGIN select top 1 @UID_DynamicGroup = g.UID_SingleGuid  from @Groups g  if exists (select top4 1 1 from DynamicGroup where UID_DynamicGroup = @UID_DynamicGroup ) begin exec QER_PDynamicGroupMakeProc_hlp @UID_DynamicGroup end else begin exec QER_PDynamicGroupMakeProc_Drop5 @UID_DynamicGroup end delete  @Groups  where UID_SingleGuid  = @UID_DynamicGroup END END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (6'', 18, 1) WITH NOWAIT END CATCH end 7