update vs4tjobmethod set TJStTJPDNo='' where TJStTJPDNo is null
GO
update vs4tjobmethod set tjstprocessstatus=0 where tjstprocessstatus is null
GO
update vs4tjobmethod set tjstprocessstatus=0 where tjstprocessstatus=1 and (TJStTJPDNo='')
GO
update vs4tjobmethod set tjstprocessstatus=1 where tjstprocessstatus=0 and (TJStTJPDNo<>'')
GO