dbo.ATT_P47650F5671BCBA8B679125E_

1    create   procedure ATT_P47650F5671BCBA8B679125E_(@UID_AttestationPolicy varchar(38) , @CaseWhereClause nvarchar(max) , @LimitOfOldCases int 
2, @GivenObjects QBM_YParameterList readonly ) as begin declare @work QBM_YParameterList declare @Ergebnis int = 1 SET XACT_ABORT OFF BEGIN TRY insert into
3 @work (Parameter2 ) select top 2000 dt.UID_AttestationCase from ( select c.UID_AttestationCase  , ROW_NUMBER() over (partition by  c.objectkeybase order
4 by c.xdateinserted desc) as rownumber from AttestationCase c with (readpast) join ( select  ObjectKeyBase  from AttestationCase with (readpast) where 
5UID_AttestationPolicy = @UID_AttestationPolicy and IsClosed = 1 and ( @CaseWhereClause is null or ( @CaseWhereClause > ' ' and ObjectKeyBase in (select
6 Parameter1 from @GivenObjects) ) ) group by  ObjectKeyBase having COUNT(*) > @LimitOfOldCases ) as ol on c.ObjectKeyBase = ol.ObjectKeyBase where c.UID_AttestationPolicy
7 = @UID_AttestationPolicy and c.IsClosed = 1 ) as dt where dt.rownumber > @LimitOfOldCases option (maxdop 1) select @Ergebnis = @@ROWCOUNT delete AttestationCase
8 from AttestationCase ac with(forceseek) join @work w on ac.UID_AttestationCase = w.Parameter2  option (maxdop 1) END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
9 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: set lock_timeout
10 -1 return (@Ergebnis) end 
11