dbo.ATT_RAttestationReset

1create   procedure ATT_RAttestationReset (@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 declare @SlotNumberSource
3 int declare @SlotNumberTarget int declare @DBQueueToMove QBM_YDBQCSCurrentToMove declare @RowsMoved int BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue
4, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast
5) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  delete @DBQueueToMove  insert into @DBQueueToMove(UID_DialogDBQueue) select
6 cul.UID_DialogDBQueue from @DBQueueCurrent cul  left outer join AttestationCase ac with (readpast) on cul.UID_Parameter = ac.UID_AttestationCase where
7 (ac.UID_AttestationCase is null or isnull(ac.IsClosed, 0) = 1 ) if @@ROWCOUNT > 0 begin select @SlotNumberSource = @SlotNumber  select @SlotnumberTarget
8 = 0 exec @RowsMoved = QBM_PDBQCS_CurrentMoveSlot @DBQueueToMove, @SlotNumberSource, @SlotnumberTarget  delete @DBQueueCurrent from @DBQueueCurrent cu 
9join @DBQueueToMove mo on cu.UID_DialogDBQueue = mo.UID_DialogDBQueue end  insert into @ObjectKeysToCheck_Jobrunning(Parameter1, Parameter2) select x.UID_AttestationCase
10, x.XObjectKey from @DBQueueCurrent cu join AttestationCase x on cu.UID_Parameter = x.UID_AttestationCase exec @resetted = QBM_PSlotResetWhileJobRun_L 
11@DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning, @SlotNumber = @SlotNumber  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''
12, 18, 1) WITH NOWAIT END CATCH endLabel: end 
13