⬅ Back AGENCY TRANSFER RECEIVE DATAIL AND RETURN.txt
INSERT INTO T202324.DBO.COMPANY_DETAIL SELECT * FROM T202223.DBO.COMPANY_DETAIL WHERE COMPCODE NOT IN (SELECT COMPCODE FROM T202324.DBO.COMPANY_DETAIL)


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



SELECT COUNT(RTNSRNO), RTNSRNO FROM T202324.DBO.TmpGRData GROUP BY RTNSRNO HAVING COUNT(RTNSRNO)>1 


SELECT * FROM T202223.DBO.TmpPayData WHERE RECSRNO='2122000404'

SELECT * FROM T202122.DBO.RECEIVED_DETAIL WHERE RECSRNO LIKE '%404'



















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

-------------------------------------------------
---RUN IN ALL YEAR
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'

SELECT * from dbo.RECEIVED_DETAIL where recsrno ='2122000404' or recsrno='2122000574'
SELECT * from T202122.dbo.RECEIVED_DETAIL where RECCUSTCODE = '21DG002' AND RECDATE = '2021-09-15 00:00:00.000'

------------------------------------------------- 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

select * from T202021.DBO.RECEIVED_DETAIL WHERE RECSRNO LIKE '%574%' ORDER BY RECDATE

select * from T202021.DBO.RECEIVED_DETAIL WHERE RECSRNO = '000404' OR RECSRNO = '000574' 
select * from T202122.DBO.RECEIVED_DETAIL WHERE RECSRNO = '000404' OR RECSRNO = '000574' 
select * from T202223.DBO.RECEIVED_DETAIL WHERE RECSRNO = '000404' OR RECSRNO = '000574' 
select * from T202324.DBO.RECEIVED_DETAIL WHERE RECSRNO = '000404' OR RECSRNO = '000574'