SELECT COUNT(RECSRNO), RECSRNO FROM T202223.DBO.TmpPayData GROUP BY RECSRNO HAVING COUNT(RECSRNO)>1 

SELECT * FROM T202223.DBO.RECEIVED_DETAIL WHERE RECSRNO='1819092558'
SELECT * FROM T202223.DBO.TmpPayData WHERE RECSRNO ='1819092558'


SELECT * FROM T202223.DBO.TmpPayData WHERE RECSRNO LIKE '%092558%'

USE T202223

UPDATE TmpPayData SET RecSrNo=RIGHT('000000'+RecSrNo,6) WHERE LEN(RecSrNo)<10
SELECT * FROM TmpPayData WHERE LEN(RecSrNo)<10

use t202223

delete from dbo.RECEIVED_PAYMENT_DETAIL where len(recsrno)=5
delete from dbo.RECEIVED_ADDLESS_DETAIL where len(recsrno)=5
delete from dbo.RECEIVED_IMAGES_DETAIL where len(recsrno)=5
delete from dbo.RECEIVED_DETAIL where len(recsrno)=5

delete from dbo.RETURN_GOODS_ITEM_DETAIL where len(rtnsrno)=5
delete from dbo.RETURN_GOODS_ADDLESS_DETAIL where len(rtnsrno)=5
delete from dbo.RETURN_GOODS_IMAGES_DETAIL where len(rtnsrno)=5
delete from dbo.RETURN_GOODS_DETAIL where len(rtnsrno)=5