USE T202526

SELECT * INTO DeletePurSrNo FROM (SELECT VouSuppCode,VouCustCode,SuppBillNo FROM PURCHASE_DETAIL GROUP BY VouSuppCode, VouCustCode, SuppBillNo  HAVING COUNT(*)>1) AS T1
ALTER TABLE DeletePurSrNo ADD VouSrNo vARCHAR(255)
UPDATE DeletePurSrNo SET VouSrNo 

UPDATE DeletePurSrNo SET VouSrNo = T1.F1 FROM (SELECT VouNo AS F1, VouSuppCode AS F2,VouCustCode AS F3,SuppBillNo AS F4 FROM PURCHASE_DETAIL ) AS T1 WHERE T1.F2 = VouSuppCode AND T1.F3 = VouCustCode and T1.F4 = SuppBillNo


DELETE FROM PURCHASE_IMAGES_DETAIL Where VouNo IN (SELECT VouSrNo FROM DeletePurSrNo)
DELETE FROM PURCHASE_ITEM_DETAIL Where VouNo IN (SELECT VouSrNo FROM DeletePurSrNo)
DELETE FROM PURCHASE_ADDLESS_DETAIL Where VouNo IN (SELECT VouSrNo FROM DeletePurSrNo)
DELETE FROM PURCHASE_TRANSPORT_DETAIL Where VouNo IN (SELECT VouSrNo FROM DeletePurSrNo)
DELETE FROM PURCHASE_DETAIL Where VouNo IN (SELECT VouSrNo FROM DeletePurSrNo)


DROP TABLE DeletePurSrNo