
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 = isnull(bu.comments,'') + char(13)+char(10) + '2023-03-06: 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

