dbo.QBM_PBufferT_ProcessAll_Delta

1  create   procedure QBM_PBufferT_ProcessAll_Delta (@ModuleName varchar(3) ) as begin declare @DebugLevel char(1) = 'W'  SET XACT_ABORT OFF BEGIN
2 TRY  if OBJECT_ID('tempdb..#QBMBufferTransferOneTable') is null begin  create table #QBMBufferTransferOneTable (ColumnName varchar(30) collate database_default
3 , ObjectKeyOfRow varchar(138) collate database_default  , ContentShort nvarchar(400) collate database_default , HasContentFull bit default 0 , ContentFull
4 nvarchar(max) collate database_default ) end if exists (select top 1 1 from QBMBufferTransfer t where t.TableName = 'QBMNonLinearDepend' ) begin  truncate
5 table #QBMBufferTransferOneTable exec QBM_PBufferT_ProcAll_Delta_i @Modulename, 'QBMNonLinearDepend' delete QBMBufferTransfer where TableName = 'QBMNonLinearDepend'
6 end exec QBM_PBufferT_DeleteNonlinear @ModuleName  exec QBM_PBufferT_ProcAll_Delta_i @Modulename, '%' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default
7 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: truncate table #QBMBufferTransferOneTable
8 end 
9