UPDATE VS4TBankPattern SET TBnPUploadCode=(SELECT TBnKUploadCode FROM VS4TBank WHERE VS4TBank.TBnkCode=VS4TBankPattern.TBnPCode)
GO
UPDATE VS4TBankPattern SET TBnPUploadCustom1=(SELECT TBnKUploadCustom1 FROM VS4TBank WHERE VS4TBank.TBnkCode=VS4TBankPattern.TBnPCode)
GO