USE T202526



SELECT COUNT(RECSRNO), COMPSRNO FROM RECEIVED_DETAIL GROUP BY COMPSRNO HAVING COUNT(COMPSRNO)>1

UPDATE RECEIVED_DETAIL SET COMPSRNO = RECSRNO