update vs4tpoptrans set TPPDType=1 where TPPDType=0 or TPPDType is null
GO
update vs4tpoptrans set TPPDDisWeightText=((TPPDDisWeightText)*(-1)) , TPPDDisWeightPC=((TPPDDisWeightPC)*(-1)) , TPPDDisWeightFix=((TPPDDisWeightFix)*(-1))
GO