UPDATE vs4tchequerec Set TCHRChqOnHandDate=TCHRPayChqDate
GO
UPDATE vs4tchequerec Set TCHRPayChqDate=(SELECT TRVHDate FROM VS4TARVoucher WHERE VS4TARVoucher.trvhno=vs4tchequerec.TCHRTRVRTRVHNo) WHERE TCHRTRVRTRVHNo<>'' and TCHRTRVRTRVHNo is not null
GO
UPDATE vs4tchequerec Set TCHRPayChqDate=TCHRChqOnHandDate WHERE TCHRPayChqDate is null
GO
 