update vs4tteasurytrans set TTeTCancelstatus=(select TPTRCancelstatus from VS4TPOSTransfer where ttetrefno=TPTRNo) where Ttetrefno like 'PT%'
GO
update vs4tteasurytrans set TTeTCancelstatus=0 where TTeTCancelstatus is null
GO