dbo.QBM_PViewBuildR_intern

1       create   procedure QBM_PViewBuildR_intern ( @UID_DialogTableR varchar(38), @GenProcID varchar(38) , @ModuleName varchar(3) = '' , @AutoCorrectColumns
2 bit = 0 ) as begin  declare @SQLcmd nvarchar(max) declare @TableNameR varchar(38) declare @DebugSwitch int = 0 declare @DebugLevel varchar(1) = 'W' SET
3 XACT_ABORT OFF BEGIN TRY select @TableNameR = dbo.QBM_FGITableName(@UID_DialogTableR) if exists (select top 1 1 from information_schema.tables where table_name
4 = @TableNameR and table_type = 'VIEW' ) and not exists (select top 1 1 from dialogtable t where t.TableName = @TableNameR ) begin exec QBM_PViewDrop @TableNameR
5 end if not exists (select top 1 1 from DialogTable t where t.TableName = @TableNameR and t.TableType = 'R' ) begin goto endLabel end if not exists (select
6 top 1 1 from DialogTable t where t.UID_DialogTable = @UID_DialogTableR ) begin goto endLabel end if @DebugSwitch > 0 begin select * from QBMViewAddOn 
7where UID_DialogTable = @UID_DialogTableR end  exec QBM_PViewBuild_FromAddOn @UID_DialogTableR if @AutoCorrectColumns = 1 begin exec QBM_PDialogColumnDelete
8 @TableNameR , @GenProcID exec QBM_PDialogColumnInsert @TableNameR , @GenProcID, @ModuleName end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default 
9declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 
10