ALTER TABLE VS4TJobMB
	DROP COLUMN TJbMUseDate
GO
ALTER TABLE VS4TJobMB ADD
	TJbMStartDate datetime NULL
GO
UPDATE VS4TJobMB SET TJbMStartDate=(SELECT TOP 1 TJStStartDate FROM VS4TJobMethod  WHERE TJStTJbMTJobNo=TJbMTJobNo AND TJStTJbMLn=TJbMLn ORDER BY TJStStartDate)
GO 
UPDATE VS4TJobMB SET TJbMStartDate=TJbMSourceDate WHERE TJbMStartDate is NULL
GO