dbo.QBM_ZViewBuildP

1   create   procedure QBM_ZViewBuildP (@SlotNumber int , @UID_DialogTable_Param varchar(38) , @dummy varchar(38) , @GenProcID varchar(38) ) AS begin
2 declare @UID_DialogTable varchar(38) declare @tableGUID QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int BEGIN TRY insert into @tableGUID
3(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 = 'P' 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_PViewBuildP_intern @UID_DialogTable , @GenProcID , @AutoCorrectColumns = 1 end else begin exec QBM_PViewBuildP_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