⬅ Back INSERT BANK BOOK RECEIVE ENTRIES TO BANK BOOK PAYMENT.sql
USE T26S003

SELECT MAX(BKSRNO) FROM PAYMENT_BANK_BOOK_DETAIL WHERE LEN(BKSRNO)=6
--72

INSERT INTO PAYMENT_BANK_BOOK_DETAIL SELECT RIGHT('000000'+CONVERT(VARCHAR(255),CONVERT(BIGINT,BkSrNo)+36),6) AS BKSRNO, BkAccCode, BkBankAccCode, BkChequeAmt, BkChequeDate, BkRemark, BkCurDate, BkCurTime, BkUName, BkClearingDate, BkChequeNo, BkTCSPerc, BkTCSAmt FROM RECEIVED_BANK_BOOK_DETAIL  WHERE LEN(BKSRNO)=6 AND BKSRNO>='000037' AND BKSRNO<='000077'
INSERT INTO PAYMENT_BANK_BOOK_ADDLESS_DETAIL SELECT RIGHT('000000'+CONVERT(VARCHAR(255),CONVERT(BIGINT,BkSrNo)+36),6) AS BKSRNO, BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus, '' AS BkTDSPartyCode FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=6 AND BKSRNO>='000037' AND BKSRNO<='000077'

DELETE FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=6 AND BKSRNO>='000037' AND BKSRNO<='000077'
DELETE FROM RECEIVED_BANK_BOOK_DETAIL  WHERE LEN(BKSRNO)=6 AND BKSRNO>='000037' AND BKSRNO<='000077'