dbo.QBM_PNonlinear_SetFound

1 create   procedure QBM_PNonlinear_SetFound as begin  declare @TableName varchar(30) declare @DebugSwitch int = 0 declare @Tablenames QBM_YCursorBuffer
2 declare @ElementCount int declare @ElementIndex int declare @Pattern nvarchar(max) = '
3update 	@TableName@
4	set XTouched = ''P''
5	from  QBMNonLinearDepend x join  @TableName@ y on x.ObjectKeyOwner = y.XObjectKey
6
7'
8 declare @SQLCmd nvarchar(max) SET XACT_ABORT OFF BEGIN TRY insert into @Tablenames(Ident1) select distinct v.TableName from QBM_VNonlinearDeleteCandidates
9 v select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @TableName = bu.Ident1 from @Tablenames
10 bu where bu.ElementIndex = @ElementIndex select @SQLCmd = REPLACE(@Pattern, '@TableName@', @TableName) if @DebugSwitch > 0 begin print @sqlcmd end exec
11 QBM_PExecuteSQLWithRetry_LLP @SQLStatement = @SQLCmd , @LockTimeout_ms = default , @MaxWaitTimeForLock_s = 4.0 , @ProcIDForJournal = default , @HandleErrorSilent
12 = 0 select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
13() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 
14