dbo.QBM_PDCB6A2129D7D15765BA077A_

1create   procedure QBM_PDCB6A2129D7D15765BA077A_ (@Portion int , @AllObjectKeysIn QBM_YObjectKeyAndPortion readonly  , @TableToDelete varchar (30
2)     , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readOnly    , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority
3 int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional
4 nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @ObjectKeys_Part QBM_YParameterList declare @Sammler
5 nvarchar(max) declare @ObjectKeysAffected QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys_Part(Parameter1) select i.Objectkey 
6from @AllObjectKeysIn i where i.Portion = @Portion if @@ROWCOUNT = 0 begin goto endLabel end select @sammler = concat('XObjectKey in ' , dbo.QBM_FCVParameter1AsOneInClause
7(@ObjectKeys_Part) )  if not exists (select top 1 1 from @AdditionalObjectKeysAffected where Parameter1 > ' ' and Parameter2 is null ) begin insert into
8 @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a join @ObjectKeys_Part s on a.Parameter2 = s.Parameter1 union 
9select Parameter1 from @ObjectKeys_Part end else begin  insert into @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected
10 a union select Parameter1 from @ObjectKeys_Part end exec QBM_PJobCreate_SQLDel @TableToDelete , @Sammler , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError
11 , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName END TRY BEGIN CATCH
12 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 
13