dbo.ATT_PAttestationHelperFill_i

1create   procedure ATT_PAttestationHelperFill_i (@SlotNumber int , @isNewDecisionLevel int ) as begin  declare @UID_AttestationCase varchar(38) 
2declare @GenProcID varchar(38) declare @DebugLevel char(1) = 'W' declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex
3 int declare @DBQueueCurrent QBM_YDBQueueCurrent declare @SQLCmdWithRetry nvarchar(max) SET XACT_ABORT OFF 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 insert into @ElementBuffer (UID1, UID2) select uid_parameter, GenprocID from
6 @DBQueueCurrent p select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @UID_AttestationCase
7 = bu.UID1 , @GenProcID = bu.UID2 from @ElementBuffer bu where bu.ElementIndex = @ElementIndex exec ATT_PAttestationHelperFill @UID_AttestationCase, @GenprocID
8, @isNewDecisionLevel = @isNewDecisionLevel select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar
9(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 
10