dbo.TSB_RUNSGroupB3InUNSGroupB3

1create   procedure TSB_RUNSGroupB3InUNSGroupB3 (@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, 'UNSGroupB3', 'uid_UNSGroupB3', @SlotNumber if @resetted > 0 begin delete  @DBQueueCurrent from @DBQueueCurrent v left outer join
6 QBMDBQueueCurrent cu with (readpast) on v.UID_DialogDBQueue = cu.UID_DialogDBQueue and cu.SlotNumber = @SlotNumber where cu.UID_DialogDBQueue is null 
7end if 1 = dbo.DPR_FGIProjectionRootRunning ('UnsRootB') begin insert into @ObjectKeysToCheck_Projection(Parameter1, Parameter2) select cu.UID_Parameter
8, ro.XObjectKey from @DBQueueCurrent cu join UNSGroupB3 x on cu.UID_Parameter = x.UID_UNSGroupB3 join UNSRootB ro on x.UID_UNSRootB = ro.UID_UNSRootB
9 exec @resetted = DPR_PSlotResetWhileProj_L @DBQueueCurrent, @ObjectKeysToCheck_Projection, @MyName, @SlotNumber  end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
10 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 
11