Back to OIM Explorer

dbo.QBM_PTempQueueEnd

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.304 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_FGISessionContext source text reference
  • references source dbo.QBM_P1B7262FC192C886D0EB9F74_ source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL65 lines
1CREATE PROCEDURE QBM_PTempQueueEnd2AS3BEGIN4  DECLARE @TaskDefs QBM_YCursorBuffer5  DECLARE @ElementCount int6  DECLARE @ElementIndex int7  DECLARE @UID_Task varchar(38)8  DECLARE @PondGroup varchar(38)9  SET XACT_ABORT OFF10  BEGIN TRY11    SELECT @PondGroup = dbo.QBM_FGISessionContext('QBMDBQueuePond')12    IF @PondGroup > ' '13    BEGIN14      INSERT INTO QBMDBQueuePond(UID_Task,15      Object,16      SubObject,17      GenProcID,18      PondGroup,19      InsertDate)20      SELECT21        e.UID_Task,22        e.Object,23        e.SubObject,24        e.GenProcID,25        @PondGroup,26        GETUTCDATE()27      FROM #QBMDBQueueTemp e28      EXEC QBM_PSessionContextSet 'INSERTEDINTODBQUEUE',29      '1' truncate TABLE #QBMDBQueueTemp30      GOTO endLabel31    END32    INSERT INTO @TaskDefs(UID1)33    SELECT x.UID_Task34    FROM(35    SELECT36      t.UID_Task AS UID_Task,37      MAX(mo.PathLength) AS PathLength38    FROM #QBMDBQueueTemp t39    JOIN QBMDBQueueTaskMetric mo40      ON t.UID_Task = mo.UID_Task41    GROUP BY t.UID_Task) AS x42    ORDER BY x.PathLength DESC43    SELECT @ElementCount = @@ROWCOUNT44    SELECT @ElementIndex = 145    WHILE @ElementIndex <= @ElementCount46    BEGIN47      SELECT TOP 1 @UID_Task = bu.UID148      FROM @TaskDefs bu49      WHERE50        bu.ElementIndex = @ElementIndex51      EXEC QBM_P1B7262FC192C886D0EB9F74_ @UID_Task52      SELECT @ElementIndex += 153    END54    truncate TABLE #QBMDBQueueTemp55  END TRY56  BEGIN CATCH57    EXEC QBM_PSessionErrorAdd DEFAULT58    RAISERROR('',59    18,60    1)61      WITH NOWAIT62  END CATCH63  endLabel:64  RETURN65END
Open raw exported source
SQL ยท Raw10 lines
1create   procedure QBM_PTempQueueEnd as begin declare @TaskDefs QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int declare @UID_Task2 varchar(38) declare @PondGroup varchar(38) SET XACT_ABORT OFF BEGIN TRY select @PondGroup = dbo.QBM_FGISessionContext('QBMDBQueuePond') if @PondGroup 3> ' ' begin insert into QBMDBQueuePond(UID_Task, Object, SubObject, GenProcID, PondGroup, InsertDate) select e.UID_Task, e.Object, e.SubObject, e.GenProcID4, @PondGroup, GETUTCDATE() from #QBMDBQueueTemp e  exec QBM_PSessionContextSet 'INSERTEDINTODBQUEUE', '1' truncate table #QBMDBQueueTemp goto endLabel 5end insert into @TaskDefs (UID1 ) select x.UID_Task from ( select t.UID_Task as UID_Task, MAX(mo.PathLength) as PathLength from #QBMDBQueueTemp t join 6QBMDBQueueTaskMetric mo on t.UID_Task = mo.UID_Task group by t.UID_Task ) as x order by x.PathLength desc select @ElementCount = @@ROWCOUNT select @ElementIndex7 = 1     while @ElementIndex <= @ElementCount begin select top 1 @UID_Task = bu.UID1 from @TaskDefs bu where bu.ElementIndex = @ElementIndex exec QBM_P1B7262FC192C886D0EB9F74_8 @UID_Task select @ElementIndex += 1 end  truncate table #QBMDBQueueTemp END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH9 NOWAIT END CATCH endLabel: return end 10