USE T202425

SELECT * INTO Tmp_RECEIVED_IMAGES_DETAIL FROM (SELECT DISTINCT * FROM RECEIVED_IMAGES_DETAIL) AS T1
SELECT * INTO Tmp_RECEIVED_ADDLESS_DETAIL FROM (SELECT DISTINCT * FROM RECEIVED_ADDLESS_DETAIL) AS T1
SELECT * INTO Tmp_RECEIVED_PAYMENT_DETAIL FROM (SELECT DISTINCT * FROM RECEIVED_PAYMENT_DETAIL) AS T1
SELECT * INTO Tmp_RECEIVED_DETAIL FROM (SELECT DISTINCT * FROM RECEIVED_DETAIL) AS T1
        
DELETE FROM RECEIVED_IMAGES_DETAIL
DELETE FROM RECEIVED_ADDLESS_DETAIL
DELETE FROM RECEIVED_PAYMENT_DETAIL
DELETE FROM RECEIVED_DETAIL

INSERT INTO RECEIVED_IMAGES_DETAIL SELECT * FROM Tmp_RECEIVED_IMAGES_DETAIL
INSERT INTO RECEIVED_ADDLESS_DETAIL SELECT * FROM Tmp_RECEIVED_ADDLESS_DETAIL
INSERT INTO RECEIVED_PAYMENT_DETAIL SELECT * FROM Tmp_RECEIVED_PAYMENT_DETAIL
INSERT INTO RECEIVED_DETAIL SELECT * FROM Tmp_RECEIVED_DETAIL
        
DROP TABLE Tmp_RECEIVED_IMAGES_DETAIL
DROP TABLE Tmp_RECEIVED_ADDLESS_DETAIL
DROP TABLE Tmp_RECEIVED_PAYMENT_DETAIL
DROP TABLE Tmp_RECEIVED_DETAIL

UPDATE RECEIVED_DETAIL SET RECAMT = T1.F1 FROM (SELECT PAIDAMT AS F1, RECSRNO AS F2 FROM RECEIVED_ADDLESS_DETAIL) AS T1 WHERE T1.F2 = RECSRNO
DELETE FROM RECEIVED_PAYMENT_DETAIL
INSERT INTO RECEIVED_PAYMENT_DETAIL SELECT RecSrNo, 1, RecCashCheque, RecChequeNo, RecDate, RecBankName, RecAmt, CompCode FROM RECEIVED_DETAIL