use t202526

select * into #DelSrNo from (select RECSRNO from received_addless_detail where status='ON A/C' AND LEN(RECSRNO)=10 GROUP BY RECSRNO HAVING COUNT(PAIDAMT)>1) as t1
`
delete from RECEIVED_IMAGES_DETAIL where recsrno in (select recsrno from #DelSrNo)
delete from RECEIVED_PAYMENT_DETAIL where recsrno in (select recsrno from #DelSrNo)
delete from received_addless_detail where recsrno in (select recsrno from #DelSrNo)
delete from received_detail where recsrno in (select recsrno from #DelSrNo)