select * from dy2022.dbo.TAXDETAIL where taxtype=3
/*
update dy2022.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2021.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2020.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2019.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2018.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2017.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2016.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2015.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2014.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2013.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3
update dy2012.dbo.TAXDETAIL set taxtype=4 where TT_DESC='THOMSON' and taxtype=3

delete from dy2022.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2022.dbo.property where taxdistric='01')
delete from dy2021.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2021.dbo.property where taxdistric='01')
delete from dy2020.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2020.dbo.property where taxdistric='01')
delete from dy2019.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2019.dbo.property where taxdistric='01')
delete from dy2018.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2018.dbo.property where taxdistric='01')
delete from dy2017.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2017.dbo.property where taxdistric='01')
delete from dy2016.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2016.dbo.property where taxdistric='01')
delete from dy2015.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2015.dbo.property where taxdistric='01')
delete from dy2014.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2014.dbo.property where taxdistric='01')
delete from dy2013.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2013.dbo.property where taxdistric='01')
delete from dy2012.dbo.taxdetail where taxtype=4 and  perskey > 0 and perskey in (select perskey from dy2012.dbo.property where taxdistric='01')
									    
delete from dy2022.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2022.dbo.property where taxdistric='01')
delete from dy2021.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2021.dbo.property where taxdistric='01')
delete from dy2020.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2020.dbo.property where taxdistric='01')
delete from dy2019.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2019.dbo.property where taxdistric='01')
delete from dy2018.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2018.dbo.property where taxdistric='01')
delete from dy2017.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2017.dbo.property where taxdistric='01')
delete from dy2016.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2016.dbo.property where taxdistric='01')
delete from dy2015.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2015.dbo.property where taxdistric='01')
delete from dy2014.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2014.dbo.property where taxdistric='01')
delete from dy2013.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2013.dbo.property where taxdistric='01')
delete from dy2012.dbo.taxdetail where taxtype=4 and  realkey > 0 and realkey in (select realkey from dy2012.dbo.property where taxdistric='01')