select * from dy2022.dbo.property where parcel_no='0T120103000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T010030000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0065D017000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0042D006000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T05A065000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0065D035000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00340013X00' and proptype='r'

/*
update dy2022.dbo.property set bankrupt=1 where parcel_no='0T120103000' and proptype='r'
update dy2022.dbo.property set bankrupt=1 where parcel_no='0T010030000' and proptype='r'
update dy2022.dbo.property set bankrupt=1 where parcel_no='0065D017000' and proptype='r'
update dy2022.dbo.property set bankrupt=1 where parcel_no='0042D006000' and proptype='r'
update dy2022.dbo.property set bankrupt=1 where parcel_no='0T05A065000' and proptype='r'
update dy2022.dbo.property set bankrupt=1 where parcel_no='0065D035000' and proptype='r'
update dy2022.dbo.property set bankrupt=1 where parcel_no='00340013X00' and proptype='r'
*/


select * from dy2022.dbo.property where parcel_no = '00660019000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00740042000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T230086000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T330044A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0078A022000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0078A023000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T05A028000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T090024000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T250124000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T310044000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T350015000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T330036000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T330043000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T310072000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T310032000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T330008000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T110021000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00150010C00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00700001000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00280062000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T090015000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T110015000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T090027000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T090028000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T090029000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T230105000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0019A062000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00500009A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T230096000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00650131000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00650132D00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00650131000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00650132D00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T330102000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T340001B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T120187B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00650083000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0040B009000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T230019A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00530092000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00380014000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T310010000' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '00710004H00' and proptype='r'
select * from dy2022.dbo.property where parcel_no = '0T125125000' and proptype='r'

select * from dy2022.dbo.vQP_SEARCH where name='JALA USA LLC'
select * from dy2022.dbo.vQP_SEARCH where name like 'PROJECT COORDINATION' 

/*
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00660019000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00740042000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T230086000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T330044A00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0078A022000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0078A023000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T05A028000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T090024000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T250124000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T310044000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T350015000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T330036000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T330043000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T310072000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T310032000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T330008000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T110021000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00150010C00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00700001000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00280062000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T090015000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T110015000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T090027000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T090028000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T090029000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T230105000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0019A062000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00500009A00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T230096000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00650131000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00650132D00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00650131000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00650132D00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T330102000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T340001B00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T120187B00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00650083000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0040B009000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T230019A00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00530092000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00380014000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T310010000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '00710004H00' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no = '0T125125000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='00100073000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T350039000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T350119000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T250122000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0036a053000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='00310014000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T250098000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T250017000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T210010000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T220061000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T320089000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T250165000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T300007000' and proptype='r'
update dy2022.dbo.property set appeal=1, appeal100=1 where parcel_no='0T050033000' and proptype='r'

*/

/*
partial payment

update dy2022.dbo.property set pay_plan=1 where parcel_no='00750025F00' and proptype='r'
*/

select * from dy2022.dbo.property where parcel_no='0031B003000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0031B004000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0031B005000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T130067000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T140129001' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00360039000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00360038000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00110047000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00250002000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00250003000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00520009000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00740022000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00740070000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00790059000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T070029000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T140014000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00020009000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00080020000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00080021000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00150008000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00160001000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0040A063G00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0040A063H00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00410035000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00420092000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00430053A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00430077000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00430015000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00520035B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0053A010000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00560014000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00640093000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00660022000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00740018000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00740019000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00780011000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00780040000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00790007000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00790014C00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00800105000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T010076000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T080015000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T080037000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T100009000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T160029000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T300016000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T350157000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T350159000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00390052000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00430049000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00650180000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T310067000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T310067C01' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0031B003000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0031B004000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T130067000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T140129001' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00410070000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00470005A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00810010000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00470005A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280015000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280013A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280013B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00520028000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T240001000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00750013000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0036A008000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0065D032000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00620082000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00650077000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00320057000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00750056A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00360036B20' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00270019000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T120148000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00780024001' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00660098000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0061A011000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00800107000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00140007000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00140008000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00140004000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00650133000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T330024000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00360036B02' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00420039000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0042B006000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0042B044000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0064A013000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T140048000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T150096000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T230149000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T310017000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T330028000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T330039000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T330055000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T330112000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T390002000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T390023000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00290006G00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00320051A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0040E024000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T390001000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T330080000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T390003000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0031A015A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T310053A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='065A0012000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='065D0007000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00290011000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T300047000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280024000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280021000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280023000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280023A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280023B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280023C00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280023F00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280023G00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00080003000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280026000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T31A005A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T31A006000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T31A007000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T31A009000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T31A011000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00160040000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00170006E00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00170006F00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00170006G00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00170006H00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00400006000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00400006H00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T080033000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00400006B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00080024A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280027000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T230121000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0008024B000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00440003A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00520055A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00400008B00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00400008C00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00420032A00' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00790056000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00640092000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0020A002000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T090097000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T120097000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0042B044000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00280020000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0T130086000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0042B006000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00290012000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='0031B005000' and proptype='r'
select * from dy2022.dbo.property where parcel_no='00650182000' and proptype='r'

/*
update dy2022.dbo.property set guarantee=1 where parcel_no='0031B003000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0031B004000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0031B005000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T130067000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T140129001' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00360039000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00360038000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00110047000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00250002000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00250003000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00520009000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00740022000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00740070000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790059000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T070029000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T140014000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00020009000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00080020000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00080021000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00150008000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00160001000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0040A063G00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0040A063H00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00410035000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00420092000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00430053A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00430077000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00430015000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00520035B00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0053A010000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00560014000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00640093000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00660022000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00740018000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00740019000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00780011000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00780040000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790007000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790014C00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00800105000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T010076000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T080015000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T080037000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T100009000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T160029000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T300016000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T350157000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T350159000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00390052000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00430049000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00650180000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T310067000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T310067C01' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0031B003000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0031B004000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T130067000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T140129001' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00410070000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00470005A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00810010000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00470005A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280015000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280013A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280013B00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00520028000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T240001000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00750013000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0036A008000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0065D032000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00620082000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00650077000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00320057000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00750056A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00360036B20' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00270019000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T120148000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00780024001' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00660098000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0061A011000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00800107000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00140007000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00140008000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00140004000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00650133000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T330024000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00360036B02' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00420039000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0042B006000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0042B044000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0064A013000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T140048000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T150096000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T230149000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T310017000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T330028000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T330039000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T330055000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T330112000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T390002000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T390023000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00290006G00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00320051A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0040E024000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T390001000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T330080000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T390003000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0031A015A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T310053A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='065A0012000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='065D0007000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00290011000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T300047000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280024000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280021000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280023000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280023A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280023B00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280023C00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280023F00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280023G00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00080003000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280026000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T31A005A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T31A006000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T31A007000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T31A009000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T31A011000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00160040000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00170006E00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00170006F00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00170006G00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00170006H00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00400006000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00400006H00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T080033000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00400006B00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00080024A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280027000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T230121000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0008024B000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00440003A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00520055A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00400008B00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00400008C00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00420032A00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790056000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00640092000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0020A002000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T090097000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T120097000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0042B044000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00280020000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0T130086000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0042B006000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00290012000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='0031B005000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00650182000' and proptype='r'

update dy2022.dbo.property set guarantee=1 where parcel_no='0079B011000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790076B00' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790075000' and proptype='r'
update dy2022.dbo.property set guarantee=1 where parcel_no='00790076000' and proptype='r'
*/

update pu set pu.exempt=1 
from dy2022.dbo.property pu 
inner join dy2022.dbo.PROPERTY_ITEMS i on i.PROPERTYKEY=pu.PROPERTYKEY and i.DIGCLASS='E'


select * from taxfee

update bu set 
	bu.GED = 7
	, bu.ADMINISTRATION = 5
	, bu.FIFA = case when bu.ADV_TAX < 100 then 10 else 20 end 
	, bu.COLLECT_FEES = 60 
	, bu.total = bu.total + 60 + 5 + 7 + case when bu.ADV_TAX < 100 then 10 else 20 end 
	, bu.balance_due = balance_due + 60 + 5 + 7 + case when bu.ADV_TAX < 100 then 10 else 20 end
	, bu.COMMENTS = bu.comments + char(13)+char(10) + '2023-03-03: Tax Sale charges added (FIFA, GED, ADMIN, COLLECT-FEES)'
	--select *
	from bill bu 
	inner join property p on p.PROPERTYKEY=bu.PROPERTYKEY and isnull(p.GUARANTEE,0)=0 and isnull(p.BANKRUPT,0)=0 and isnull(p.APPEAL,0)=0 and p.PROPTYPE in ('r','p') and bu.BALANCE_DUE>0


