dbo.QBM_PTempQueueEnd

1create   procedure QBM_PTempQueueEnd as begin declare @TaskDefs QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int declare @UID_Task
2 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.GenProcID
4, @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 @ElementIndex
7 = 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) WITH
9 NOWAIT END CATCH endLabel: return end 
10