use T21L001

INSERT INTO RECEIVED_BANK_BOOK_DETAIL SELECT '7'+RIGHT(BkSrNo,4), BkAccCode, BkBankAccCode, BkPartyBankName, BkChequeAmt, BkChequeDate, BkRemark, BkClearingSlipNo, BkCurDate, BkCurTime, BkUName, BkClearingDate, BkChequeNo, PartySlipNo, BkTCSPerc, BkTCSAmt FROM RECEIVED_BANK_BOOK_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
INSERT INTO RECEIVED_BANK_BOOK_ADDLESS_DETAIL SELECT '7'+RIGHT(BkSrNo,4), BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus, BkDisBal, BkRDBal, BkGRBal, BkIntBal, DisputeRemark, BkTDSAmt, BkTCSCalcOn, BkTCSPerc, BkTCSAmt FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5

DELETE FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5
DELETE FROM RECEIVED_BANK_BOOK_DETAIL WHERE LEFT(BkSrNo,1)= '0' AND LEN(BkSrNo)=5