dbo.ADS_RBaseTreeOwnsObjectPrepair

1create   procedure ADS_RBaseTreeOwnsObjectPrepair (@SlotNumber int) AS begin declare @ObjectKeysToCheck_Projection QBM_YParameterList declare @ObjectKeysToCheck_Jobrunning
2 QBM_YParameterList declare @MyName nvarchar(64) = object_name(@@procid) declare @DBQueueCurrent QBM_YDBQueueCurrent declare @resetted int BEGIN TRY insert
3 into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID
4 from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  exec @resetted = QBM_PSlotResetOnMissingItem_L
5 @DBQueueCurrent, 'BaseTree', 'UID_Org', @SlotNumber if @resetted > 0 begin delete  @DBQueueCurrent from @DBQueueCurrent v left outer join QBMDBQueueCurrent
6 cu with (readpast) on v.UID_DialogDBQueue = cu.UID_DialogDBQueue and cu.SlotNumber = @SlotNumber where cu.UID_DialogDBQueue is null end  insert into @ObjectKeysToCheck_Jobrunning
7(Parameter1, Parameter2) select x.UID_Org, x.XObjectKey from @DBQueueCurrent cu join BaseTree x on cu.UID_Parameter = x.UID_Org exec @resetted = QBM_PSlotResetWhileJobRun_L
8 @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning, @SlotNumber = @SlotNumber   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR 
9('', 18, 1) WITH NOWAIT END CATCH endLabel: end 
10