insert into dy2025.dbo.GOVWIN_BATCH (PROPERTYKEY, I_U, BILL_NO, BILL_YEAR, TRANSMIT)
select PROPERTYKEY, 'U' I_U, BILL_NO, BILL_YEAR, 0 TRANSMIT 
from dy2025.dbo.bill where COMMENTS LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'

INSERT INTO DY2025.dbo.BILL_TRANSACTIONS (BILL_NO, T_AMOUNT, T_DATE, T_TYPE, COMMENTS, LOGINID, COMPNAME, DBNAME, BILL_YEAR, BILL_TYPE) SELECT BILL_NO, 65, GETDATE(), 'COLLECT_FEES', 'REMOVED', 'GATCS', HOST_NAME(), DB_NAME(), BILL_YEAR, BILL_TYPE FROM DY2025.dbo.BILL WHERE BALANCE_DUE>0 and COMMENTS LIKE '%Phase 1 $65 collect fee added for DTS - 20260401' 

UPDATE DY2025.DBO.BILL SET BALANCE_DUE=BALANCE_DUE-65, TOTAL=TOTAL-65, COLLECT_FEES=COLLECT_FEES-65
	, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee removed for DTS - 20260401' 
	WHERE BALANCE_DUE>0 AND COMMENTS LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'

UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34719 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31591 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16873 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=45708 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28707 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24512 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8034 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21792 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=38275 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36508 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=50247 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30053 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37905 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40697 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=669 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30984 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14957 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4168 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3518 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4169 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4170 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4171 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4172 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34184 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49022 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49028 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23888 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49183 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49185 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49186 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49187 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49188 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49189 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49023 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49024 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49025 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49021 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49026 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49027 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43588 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43589 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17536 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29135 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=15086 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37385 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35354 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=50625 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3134 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28709 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36468 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=33798 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35998 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=11056 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=11057 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2581 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43659 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47691 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13503 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=11722 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26683 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=15952 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30985 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3868 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=15252 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1752 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19321 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2548 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=46882 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14441 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9476 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26391 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26392 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35464 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32481 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30988 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37228 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=12502 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=22743 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26827 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28742 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=39630 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31882 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32838 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24045 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19709 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31324 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36465 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36466 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13502 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36684 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14759 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3931 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8035 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4959 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34611 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20501 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26925 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32370 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1753 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4357 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36058 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29598 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28438 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44160 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28734 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=5526 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35359 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3932 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3933 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47263 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4982 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37856 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19075 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19076 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36283 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28748 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25932 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2324 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20861 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1755 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26401 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28362 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32904 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32905 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36469 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36470 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36472 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36473 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49204 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28442 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1140 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31634 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25933 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=11534 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23870 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=46958 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2378 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25352 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37744 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19721 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=5144 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7656 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23268 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13902 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37742 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=11052 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34754 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26402 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23270 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4858 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20851 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26397 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26403 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23123 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=5890 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41277 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8844 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28864 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8036 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=45746 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=5563 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29998 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48295 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44340 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26400 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36685 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24155 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=15755 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=33748 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29220 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41447 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48276 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28749 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35651 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26404 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13908 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=12029 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3541 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37737 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14438 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13909 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13301 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4772 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31213 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25536 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28750 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28751 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20512 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48995 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16573 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41773 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26793 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26997 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=22857 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32740 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=46030 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=15953 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24425 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=27034 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47184 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4016 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24409 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31836 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=42081 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=27760 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28455 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7964 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40094 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28752 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31957 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29091 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48982 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47541 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17248 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20502 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=6718 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3934 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=576 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19074 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36683 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19198 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47520 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21431 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7892 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7987 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1493 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17547 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2698 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47363 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=670 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43993 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40836 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43471 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29374 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20868 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3870 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20121 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20503 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23841 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23826 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8825 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47656 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28745 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16604 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41132 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47365 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40320 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48296 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49227 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43159 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24144 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19907 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31210 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14398 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37829 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28753 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48984 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31781 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16524 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31816 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=6097 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24145 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29931 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29932 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20236 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3140 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=393 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26768 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26769 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3432 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=6440 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37329 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48979 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34525 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21288 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29480 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=46029 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16574 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7651 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9466 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9467 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9468 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9471 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9469 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=9470 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28754 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28755 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28758 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28759 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40633 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44429 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20427 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49194 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26398 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20710 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2664 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41880 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41881 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4666 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47454 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19717 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=18904 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37672 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2427 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43196 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=10018 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=32118 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40678 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36824 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21377 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16040 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=46009 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40490 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43130 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14423 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14425 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=194 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=22434 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3935 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8441 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44414 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31057 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3321 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25133 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37952 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=42479 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49823 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3833 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19077 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14710 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24511 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44767 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36687 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1602 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43363 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8632 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37231 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29478 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3936 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3937 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=746 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=33970 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3725 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14932 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=27094 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14562 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1603 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28258 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=27469 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=27470 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37847 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19204 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24602 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21225 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21224 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=22035 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49517 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30025 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49558 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47513 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3789 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1317 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44923 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1124 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25830 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37620 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28760 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41414 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16681 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34602 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23820 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=42732 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36620 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=26723 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16003 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3093 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30883 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1395 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=24306 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1604 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=5047 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1484 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41245 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=5338 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=564 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30453 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8039 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35286 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=2441 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35028 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40786 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=15740 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28615 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14440 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3082 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16649 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1502 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28825 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17749 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=6711 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=45210 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36874 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36875 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36876 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=6891 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47401 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47402 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23152 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19174 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29481 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=35437 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=20218 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30704 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36474 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19617 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=44342 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17453 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16289 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48978 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=19934 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=27195 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7045 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=22910 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3938 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23098 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=42452 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=41490 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=3496 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=38052 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16372 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43208 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1968 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47329 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28762 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23009 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7729 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=7600 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8863 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=8832 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=21223 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=33252 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=6894 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37848 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37849 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37854 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37850 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30378 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=16721 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29482 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17851 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=37953 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43202 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=40617 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=47065 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=1606 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=25350 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=48615 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29487 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29461 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=29462 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=28616 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=17821 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=30685 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23036 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=43206 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=49181 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=23263 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13606 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13607 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=13608 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=4576 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=46979 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34603 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=12432 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=14770 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=34054 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=36467 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'
UPDATE DY2024.DBO.BILL SET BALANCE_DUE=BALANCE_DUE+65, TOTAL=TOTAL+65, COLLECT_FEES=COLLECT_FEES+65, COMMENTS=ISNULL(COMMENTS,'')+CHAR(13)+CHAR(10)+'Phase 1 $65 collect fee added for DTS - 20260401' WHERE BALANCE_DUE>0 AND BILL_NO=31577 AND BILL_YEAR=2024 AND COMMENTS NOT LIKE '%Phase 1 $65 collect fee added for DTS - 20260327%'

INSERT INTO DY2024.dbo.BILL_TRANSACTIONS (BILL_NO, T_AMOUNT, T_DATE, T_TYPE, COMMENTS, LOGINID, COMPNAME, DBNAME, BILL_YEAR, BILL_TYPE) SELECT BILL_NO, 65, GETDATE(), 'COLLECT_FEES', 'APPLIED', 'GATCS', HOST_NAME(), DB_NAME(), BILL_YEAR, BILL_TYPE FROM DY2024.dbo.BILL WHERE COMMENTS LIKE '%Phase 1 $65 collect fee added for DTS - 20260401' 
INSERT INTO DY2024.dbo.GOVWIN_BATCH (PROPERTYKEY, I_U, BILL_NO, BILL_YEAR, TRANSMIT) SELECT PROPERTYKEY, 'U', BILL_NO, BILL_YEAR, 0 FROM DY2024.dbo.BILL WHERE COMMENTS LIKE '%Phase 1 $65 collect fee added for DTS - 20260401'