dbo.QER_RPersonHasQERAssign

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