update vs4tproductmethod set TSpdDependent=0 where TSpdDependent=2
GO
update vs4tproductmethod set TSpdDependent=TSpdStep-1 where TSpdDependent=1 or TSpdDependent=3
GO

update vs4tjobmethod set TJStDependent=0 where TJStDependent=2
GO
update vs4tjobmethod set TJStDependent=TJStLn-1 where TJStDependent=1 or TJStDependent=3
GO

update vs4tjobProductionM set TJPMDependent=0 where TJPMDependent=2
GO
update vs4tjobProductionM set TJPMDependent=TJPMStep-1 where TJPMDependent=1 or TJPMDependent=3
GO