ALTER TABLE VS4TQuickProduct ADD
	TQpdTotal money NULL,
	TQpdTotalRecord int NULL,
	TQpdTotalQuantity float(53) NULL
GO
UPDATE VS4TQuickProduct SET TQpdTotal=(select sum(TQPMStandardCost) From VS4TQuickProductMB where TQPMTQPdNo=TQPdNo)
GO
UPDATE VS4TQuickProduct SET TQpdTotalRecord=(select count(TQPMLn) From VS4TQuickProductMB where TQPMTQPdNo=TQPdNo)
GO
UPDATE VS4TQuickProduct SET TQpdTotalQuantity=(select count(TQPMLn) From VS4TQuickProductMB where TQPMTQPdNo=TQPdNo)
GO