dbo.QBM_PQBMRelationExpand

1  create   procedure QBM_PQBMRelationExpand as begin declare @UID_QBMRelation varchar(38) declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount
2 int declare @ElementIndex int SET XACT_ABORT OFF BEGIN TRY insert into @ElementBuffer (UID1) select v.UID_QBMRelation from QBM_VQBMRelation v join DialogTable
3 tp on v.UID_DialogTableParent = tp.UID_DialogTable join DialogTable tc on v.UID_DialogTableChild = tc.UID_DialogTable where v.UID_QBMRelationBase is null
4 and ( tp.TableType in ('B', 'V') or tc.TableType in ('B', 'V') ) select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount
5 begin select top 1 @UID_QBMRelation = bu.UID1 from @ElementBuffer bu where bu.ElementIndex = @ElementIndex exec QBM_PQBMRelationExpand_One @UID_QBMRelation
6 select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()
7 RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: end 
8