use T21G001

SELECT * FROM RECEIVED_BANK_BOOK_DETAIL WHERE BKSRNO='1819000603'
SELECT * FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE BKSRNO='1819000603'

drop table T21G001.DBO.BANK_DATA 
CREATE TABLE T21G001.DBO.BANK_DATA (BkSrNo Varchar(10), PaidAmt Money, OrgSrNo Varchar(10))
insert into T21G001.DBO.BANK_DATA SELECT Right(BkSrNo,6), BkChequeAmt, BkSrNo FROM T21G001.DBO.RECEIVED_BANK_BOOK_detail WHERE LEN(BKSRNO)=10
alter table T21G001.DBO.BANK_DATA Add OrgPaidAmt Money

UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=0
UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=T1.F1 FROM (SELECT BkChequeAmt AS F1, BkSrNo AS F2 FROM T18G001.DBO.RECEIVED_BANK_BOOK_DETAIL) AS T1 WHERE T1.F2 COLLATE DATABASE_DEFAULT = BkSrNo AND left(OrgSrNo,4)='1718'
UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=T1.F1 FROM (SELECT BkChequeAmt AS F1, BkSrNo AS F2 FROM T19G001.DBO.RECEIVED_BANK_BOOK_DETAIL) AS T1 WHERE T1.F2 COLLATE DATABASE_DEFAULT = BkSrNo AND left(OrgSrNo,4)='1819'
UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=T1.F1 FROM (SELECT BkChequeAmt AS F1, BkSrNo AS F2 FROM T20G001.DBO.RECEIVED_BANK_BOOK_DETAIL) AS T1 WHERE T1.F2 COLLATE DATABASE_DEFAULT = BkSrNo AND left(OrgSrNo,4)='1920'

SELECT * FROM T21G001.DBO.BANK_DATA WHERE orgpaidamt<>paidamt