dbo.QBM_PJobCreate_SQLDel_L

1  create   procedure QBM_PJobCreate_SQLDel_L (@TableToDelete varchar (30) , @XObjectKeysToDelete QBM_YParameterList readOnly , @GenProcID varchar
2(38) , @AdditionalObjectKeysAffected QBM_YParameterList readOnly    , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname
3 nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max
4) = '' , @checkForExisting bit = 0  , @QueueName nvarchar(256) = null ) as begin declare @Portion int declare @PortionMax int declare @ElementsMax int 
5declare @ElementsLen int declare @AllObjectKeysIn QBM_YObjectKeyAndPortion SET XACT_ABORT OFF BEGIN TRY if ISNULL(@BasisObjectKey, '') = '' begin select
6 top 1 @BasisObjectKey = dbo.QBM_FCVElementToObjectKey1('DialogTable', 'UID_DialogTable', t.UID_DialogTable) from DialogTable t where t.TableName = @TableToDelete
7 end  if not exists (select top 1 1 from DialogTable where TableName = @TableToDelete and IsDeactivatedByPreProcessor = 0 ) begin  goto endLabel end select
8 top 1 @ElementsLen = len(Parameter1) from @XObjectKeysToDelete if isnull(@ElementsLen, 0) = 0 begin goto endLabel end select @ElementsMax = 20000 / @ElementsLen
9 if @ElementsMax > 450 begin select @ElementsMax = 450 end insert into @AllObjectKeysIn (ObjectKey, Portion) select o.Parameter1 , ((ROW_NUMBER() over(
10 order by o.Parameter1) ) / @ElementsMax) + 1 from @XObjectKeysToDelete o select @PortionMax = max(i.Portion) , @Portion = 1 from @AllObjectKeysIn i while
11 @Portion <= @PortionMax begin exec QBM_PDCB6A2129D7D15765BA077A_ @Portion = @Portion , @AllObjectKeysIn = @AllObjectKeysIn  , @TableToDelete = @TableToDelete
12 , @GenProcID = @GenProcID , @AdditionalObjectKeysAffected = @AdditionalObjectKeysAffected , @isToFreezeOnError = @isToFreezeOnError , @Retries = @Retries
13 , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser , @WhereClauseAdditional
14 = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName select @Portion += 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
15 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 
16