ALTER TABLE VS4TSOImigration ADD
	TIMGTAILCode nvarchar(30) NULL
GO
UPDATE VS4TSOImigration Set TIMGTAILCode=(select TPBGTAILCode from VS4TProductBook WHERE VS4TProductBook.TPBGTPdtCode = VS4TSOImigration.TIMGTPdtCode) WHERE TIMGTAILCode is null
GO