----------------------------------------------------------- 	------------------------------------------------- 
-    Monthly, Quarterly and Yearly Cases Previous Year    - 	-  Top 25 Monthly, Quarterly and Yearly Cases   - 
----------------------------------------------------------- 	------------------------------------------------- 
-      Local date-time is [2023-12-02 06:00:01.460]       - 	-  Local date-time is [2023-12-02 06:00:30.773] -         
----------------------------------------------------------- 	------------------------------------------------- 
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: An existing connection was forcibly closed by the remote host.	Case Type                           |Past 4 Weeks
.	------------------------------------|------------
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Communication link failure.	Water Leak                          |        2942
	Missed Garbage Pickup               |        2154
	Water Service                       |        1788
	Sewer Wastewater                    |        1476
	Nuisance On Property                |        1001
	Traffic Signal Maintenance          |         966
	Parking Violation                   |         962
	Missed Recycling Pickup             |         836
	Street Condition                    |         779
	Container Replacement               |         674
	Street Hazard                       |         666
	Dead Animal Collection              |         633
	Traffic Signs                       |         604
	Container Repair                    |         590
	Heavy Trash Violation               |         534
	New Resident Container              |         451
	Recycling Participation NEW         |         414
	Missed Heavy Trash Pickup           |         414
	Trash Dumping or Illegal Dumpsite   |         404
	SWM Escalation                      |         400
	Drainage                            |         388
	Pothole                             |         380
	Fire Hydrant                        |         374
	Building Code Violation             |         293
	Water/Sewer/Drainage Billing        |         292
	
	Case Type                           |Past 12 Weeks
	------------------------------------|-------------
	Water Leak                          |        13395
	Missed Garbage Pickup               |         7142
	Water Service                       |         7097
	Sewer Wastewater                    |         4763
	Traffic Signal Maintenance          |         4222
	Nuisance On Property                |         3814
	Parking Violation                   |         3503
	Missed Recycling Pickup             |         3311
	Street Condition                    |         2883
	Street Hazard                       |         2749
	Container Replacement               |         2236
	Traffic Signs                       |         2137
	Dead Animal Collection              |         2030
	Container Repair                    |         1954
	Heavy Trash Violation               |         1906
	Missed Heavy Trash Pickup           |         1860
	SWM Escalation                      |         1584
	Trash Dumping or Illegal Dumpsite   |         1517
	New Resident Container              |         1460
	Fire Hydrant                        |         1449
	Recycling Participation NEW         |         1429
	Drainage                            |         1398
	Pothole                             |         1182
	Building Code Violation             |         1106
	MYR Correspondence                  |         1059
	
	Case Type                           |Past 12 Months
	------------------------------------|--------------
	Water Leak                          |         41292
	Missed Garbage Pickup               |         27157
	Water Service                       |         21228
	Sewer Wastewater                    |         19938
	Missed Recycling Pickup             |         18099
	Traffic Signal Maintenance          |         16511
	Nuisance On Property                |         14961
	Parking Violation                   |         13647
	Street Condition                    |         10913
	Street Hazard                       |         10742
	SWM Escalation                      |          9723
	Container Replacement               |          9516
	Traffic Signs                       |          8614
	Container Repair                    |          8329
	Dead Animal Collection              |          7968
	Missed Heavy Trash Pickup           |          7945
	Heavy Trash Violation               |          7083
	Drainage                            |          6740
	New Resident Container              |          6355
	Trash Dumping or Illegal Dumpsite   |          6207
	Recycling Participation NEW         |          5848
	Water Main Valve                    |          4751
	Missed Yard Waste Pickup            |          4737
	MYR Correspondence                  |          4590
	Add a Can                           |          4588