UPDATE VS4TProductBook set TPBGVisaDate=TPBGCheckDate where TPBGVisaDate is null
GO
UPDATE VS4TProductBook set TPBGDepositDate=TPBGCheckDate-7 where TPBGDepositDate is null
GO
UPDATE VS4TProductBook set TPBGLastBookDate =TPBGCheckDate where TPBGLastBookDate  is null
GO