update vs4tinventoryLOT set timcTUntCode=(select tpdttuntcode from vs4tproduct where timctpdtcode=tpdtcode) where timcTUntCode='' or timcTUntCode is null
GO
update vs4tinventoryLOT set tiMCUNITRATIO=1 WHERE tiMCUNITRATIO=0 or tiMCUNITRATIO is null
GO