dbo.QBM_ZViewBuildU

1    create   procedure QBM_ZViewBuildU (@SlotNumber int , @UID_DialogTable_Param varchar(38) , @dummy varchar(38) , @GenProcID varchar(38) ) AS 
2begin declare @UID_DialogTable varchar(38) declare @tableGUID QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int BEGIN TRY insert into
3 @tableGUID(UID1 ) select distinct x.UID_DialogTable from (           select t.UID_DialogTable, def.SortOrder from DialogTable t with (readpast) join QBMModuleDef
4 def with (readpast) on LEFT(t.uid_dialogtable, 3) = def.ModuleName where t.UID_DialogTable = @UID_DialogTable_Param and t.TableType = 'U' union select
5 @UID_DialogTable_Param, 1 from INFORMATION_SCHEMA.TABLES t with (readpast) where dbo.QBM_FGITableName(@UID_DialogTable_Param) = t.TABLE_NAME collate database_default
6 and t.TABLE_TYPE = 'VIEW' ) as x order by  x.UID_DialogTable select @ElementCount = @@rowcount select @ElementIndex = 1 while @ElementIndex <= @ElementCount
7 begin select top 1 @uid_dialogTable = bu.UID1  from @tableGUID bu where bu.ElementIndex = @ElementIndex if dbo.QBM_FCVGUIDToModuleOwner(@uid_dialogTable
8) = 'CCC' begin exec QBM_PViewBuildU_intern @UID_DialogTable , @GenProcID , @AutoCorrectColumns = 1 end else begin exec QBM_PViewBuildU_intern @UID_DialogTable
9 , @GenProcID end select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende:
10 return end 
11