Saturday, 22 October 2016

Update from Test Database to Running Database




Update TaskUpdate Set TaskEndTime = b.TaskEndTime
From TaskUpdate a
Inner Join testproduction.dbo.TaskUpdate b on a.DetTranId = b.DetTranId
and a.MasTranId = b.MasTranId and a.EntryDate = b.EntryDate
and a.TaskStartTime = b.TaskStartTime 

No comments:

Post a Comment