Use ATNDBTest
Go
Update CostDetail Set
	CostBaseRef = CostHeader.CostBaseRef,
	CostCenterRef = CostHeader.CostCenterRef
from CostDetail inner join
	CostHeader on CostHeader.Serial = CostDetail.CostHeaderRef