INSERT INTO T202324.DBO.COMPANY_DETAIL SELECT * FROM T202223.DBO.COMPANY_DETAIL WHERE COMPCODE NOT IN (SELECT COMPCODE FROM T202324.DBO.COMPANY_DETAIL)

-------------------------------------------------
use t202223
delete from dbo.RECEIVED_PAYMENT_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
delete from dbo.RECEIVED_ADDLESS_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
delete from dbo.RECEIVED_IMAGES_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
delete from dbo.RECEIVED_DETAIL where recsrno ='2122000404' or recsrno='2122000574'

use t202122
delete from dbo.RECEIVED_PAYMENT_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
delete from dbo.RECEIVED_ADDLESS_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
delete from dbo.RECEIVED_IMAGES_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
delete from dbo.RECEIVED_DETAIL where recsrno ='2122000404' or recsrno='2122000574'

------------------------------------------------- update date srno 000404 in 2020-21
------------------------------------------------- update date srno 000574 in 2020-21
------------------------------------------------- update date srno 001014 in 2021-22



2223000106
2223000149
2223001014
2223001049
2223001060
2223001178
2223001220

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

select recsrno from TmpPayData group by recsrno having count(recsrno)>1