dbo.QBM_PBufferC_ProcessAll

1     create   procedure QBM_PBufferC_ProcessAll (@ModuleOwner varchar(3)  ) as begin declare @TableName varchar(30) declare @columnname varchar(30
2) declare @DebugSwitch int = 0  declare @ColumnsToProcess QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int SET XACT_ABORT OFF BEGIN
3 TRY insert into @ColumnsToProcess (Ident1  , Ident2 ) select y.TableName, y.columnname from (select distinct bu.TableName, bu.ColumnName from QBMBufferConfig
4 bu ) as y left outer join QBM_VStartupTables s on y.TableName = s.TableName  order by isnull(s.SortOrder,1000) , y.ColumnName select @ElementCount = @@ROWCOUNT
5 select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @TableName = bu.Ident1 , @columnname = bu.Ident2 from @ColumnsToProcess
6 bu where bu.ElementIndex = @ElementIndex if @DebugSwitch > 0 begin print '----------------------------------------------------' print ' processing ' +
7 @TableName + ' ' + @columnname end exec QBM_PBufferC_ProcessOneColumn @TableName , @columnname, @ModuleOwner select @ElementIndex += 1 end  END TRY BEGIN
8 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 
9CATCH ende: end 
10