LCWTL
|
update records in tblTeamNames with number of players to zero
| No records returned. |
Delete all records from tblActualCount
| No records returned. |
create records in tblActualCount specifying number of players per team
| No records returned. |
update records in tblTeamNames with number of players registered for each team
| No records returned. |
| teamNameID | Division | TeamName | MaxNumPlayers | ActualNumPlayers | |
| 1362 | 3.0 | CCRHC | 0 | 13 | |
| 1289 | 3.0 | Del Tura | 0 | 12 | |
| 1357 | 3.0 | Fiddlesticks | 0 | 16 | |
| 1172 | 3.0 | FMRC | 0 | 16 | |
| 996 | 3.0 | Forest | 15 | 16 | |
| 1358 | 3.0 | Heritage Cove | 0 | 11 | |
| 1359 | 3.0 | Heritage Palms | 0 | 12 | |
| 1360 | 3.0 | Herons Glen AlleyGators | 0 | 14 | |
| 1361 | 3.0 | Herons Glen TopSpinners | 0 | 15 | |
| 1004 | 3.0 | Kelly Greens | 12 | 15 | |
| 1293 | 3.0 | Landings | 0 | 15 | |
| 1007 | 3.0 | Legends | 14 | 15 | |
| 1174 | 3.0 | Lexington Matchmakers | 0 | 15 | |
| 1175 | 3.0 | Lexington Racq Pacq | 0 | 14 | |
| 1294 | 3.0 | Paseo | 0 | 12 | |
| 1179 | 3.0 | Pelican Landing | 0 | 16 | |
| 1363 | 3.0 | Verandah | 0 | 15 | |
| 1392 | 3.0 Minus | Breckenridge Terminetters | 0 | 12 | |
| 1369 | 3.0 Minus | Breckenridge TieBreakers | 0 | 12 | |
| 1388 | 3.0 Minus | Cross Creek Estates | 0 | 12 | |
| 1389 | 3.0 Minus | Heritage Palms | 0 | 16 | |
| 1391 | 3.0 Minus | Landings | 0 | 16 | |
| 1390 | 3.0 Minus | Lexington | 0 | 13 | |
| 1011 | 3.5 | Breckenridge | 12 | 13 | |
| 1353 | 3.5 | CCRHC | 0 | 11 | |
| 1073 | 3.5 | CCYC | 11 | 12 | |
| 1247 | 3.5 | Del Tura | 0 | 14 | |
| 1015 | 3.5 | Fiddlesticks | 11 | 13 | |
| 1354 | 3.5 | FMRC | 0 | 12 | |
| 1017 | 3.5 | Gateway | 13 | 15 | |
| 1355 | 3.5 | Gulf Harbour | 0 | 13 | |
| 1019 | 3.5 | Herons Glen | 13 | 16 | |
| 1274 | 3.5 | Landings | 0 | 16 | |
| 1023 | 3.5 | Legends | 12 | 14 | |
| 1275 | 3.5 | Lexington | 0 | 12 | |
| 1252 | 3.5 | Park Meadow | 0 | 16 | |
| 1027 | 3.5 | Pelican Landing | 13 | 15 | |
| 1356 | 3.5 | Pelican Preserve | 0 | 16 | |
| 1254 | 3.5 | Rutenberg | 0 | 13 | |
| 1155 | 3.5 Minus | Breckenridge | 0 | 16 | |
| 1381 | 3.5 Minus | CCYC | 0 | 15 | |
| 1382 | 3.5 Minus | Colonial | 0 | 14 | |
| 1383 | 3.5 Minus | Dunes | 0 | 15 | |
| 1255 | 3.5 Minus | Estero At the Vines | 0 | 15 | |
| 1256 | 3.5 Minus | Forest | 0 | 16 | |
| 1384 | 3.5 Minus | Gulf Harbour LoveLeeLadies | 0 | 14 | |
| 1385 | 3.5 Minus | Gulf Harbour SliceGirls | 0 | 13 | |
| 1281 | 3.5 Minus | Heritage Palms | 0 | 15 | |
| 1167 | 3.5 Minus | Judd Park | 0 | 13 | |
| 1282 | 3.5 Minus | Kelly Greens | 0 | 11 | |
| 1258 | 3.5 Minus | Landings Gems | 0 | 15 | |
| 1160 | 3.5 Minus | Landings Wildcats | 0 | 13 | |
| 1154 | 3.5 Minus | Legends | 0 | 13 | |
| 1386 | 3.5 Minus | Lexington | 0 | 16 | |
| 1286 | 3.5 Minus | Park Meadow | 0 | 14 | |
| 1387 | 3.5 Minus | Paseo | 0 | 12 | |
| 941 | 4.0 | Beachview | 12 | 14 | |
| 1364 | 4.0 | Bonita Bay | 0 | 16 | |
| 1066 | 4.0 | Dunes | 0 | 12 | |
| 1069 | 4.0 | Gulf Harbour | 0 | 13 | |
| 1240 | 4.0 | HP Poachers | 0 | 13 | |
| 1266 | 4.0 | Landings 4Love | 0 | 16 | |
| 1265 | 4.0 | Landings Legends | 0 | 14 | |
| 1366 | 4.0 | Lexington | 0 | 15 | |
| 1070 | 4.0 | Park Meadow | 0 | 14 | |
| 1241 | 4.0 | Paseo | 0 | 13 | |
| 1367 | 4.0 | Pelican Landing | 0 | 16 | |
| 1373 | 4.0 Minus | CCRHC | 0 | 13 | |
| 1372 | 4.0 Minus | CCYC | 0 | 14 | |
| 1374 | 4.0 Minus | Dunes DynamicDames | 0 | 13 | |
| 1375 | 4.0 Minus | Dunes TonisTigers | 0 | 9 | |
| 1376 | 4.0 Minus | Fiddlesticks | 0 | 11 | |
| 1377 | 4.0 Minus | FMRC AceKickers | 0 | 13 | |
| 1378 | 4.0 Minus | FMRC BluCru | 0 | 13 | |
| 1379 | 4.0 Minus | Gateway | 0 | 14 | |
| 1245 | 4.0 Minus | Gulf Harbour | 0 | 11 | |
| 904 | 4.0 Minus | Legends | 11 | 14 | |
| 1380 | 4.0 Minus | Park Meadow | 0 | 12 | |
| 1199 | 60 Plus | Breckenridge | 0 | 13 | |
| 1349 | 60 Plus | CCRHC | 0 | 13 | |
| 1319 | 60 Plus | FMRC | 0 | 16 | |
| 1350 | 60 Plus | Forest | 0 | 16 | |
| 1351 | 60 Plus | Heritage Palms | 0 | 14 | |
| 1200 | 60 Plus | Landings | 0 | 16 | |
| 921 | 60 Plus | Legends | 14 | 16 | |
| 924 | 60 Plus | Sabal Springs | 10 | 14 | |
| 1201 | Bronze | Breckenridge Overheads | 0 | 12 | |
| 1321 | Bronze | Breckenridge Racketeers | 0 | 12 | |
| 1203 | Bronze | Colonial | 0 | 15 | |
| 1136 | Bronze | Cross Creek Estates | 0 | 16 | |
| 1338 | Bronze | Crown Colony | 0 | 13 | |
| 911 | Bronze | Del Tura | 11 | 12 | |
| 1138 | Bronze | Dunes | 0 | 14 | |
| 1139 | Bronze | Estero at the Vines | 0 | 13 | |
| 1322 | Bronze | FMRC | 0 | 15 | |
| 1339 | Bronze | Gulf Harbour DropShots | 0 | 15 | |
| 1324 | Bronze | Gulf Harbour Swingers | 0 | 16 | |
| 1340 | Bronze | Heritage Cove | 0 | 12 | |
| 1204 | Bronze | Heritage Palms | 0 | 14 | |
| 1341 | Bronze | Herons Glen | 0 | 16 | |
| 1140 | Bronze | Kelly Greens | 11 | 16 | |
| 913 | Bronze | Landings | 14 | 15 | |
| 1342 | Bronze | Lexington NetWorthy | 0 | 16 | |
| 1343 | Bronze | Lexington SuperShots | 0 | 16 | |
| 1141 | Bronze | Pelican Landing | 0 | 16 | |
| 1326 | Bronze | Pelican Preserve | 0 | 16 | |
| 1207 | Bronze | Seven Lakes | 0 | 12 | |
| 1235 | Dynamo | CCYC | 0 | 11 | |
| 1371 | Dynamo | Gulf Harbour | 0 | 10 | |
| 1064 | Dynamo | Paseo | 0 | 16 | |
| 1370 | Dynamo | Plantation | 0 | 15 | |
| 1327 | Dynamo | PM GGs | 0 | 13 | |
| 1237 | Dynamo | PM Tennis Junkies | 0 | 14 | |
| 972 | Gold | Breckenridge | 12 | 14 | |
| 1333 | Gold | CCRHC | 0 | 12 | |
| 1328 | Gold | CCYC | 0 | 16 | |
| 1393 | Gold | Colonial | 0 | 16 | |
| 1195 | Gold | FMRC Ace Cadettes | 0 | 14 | |
| 1311 | Gold | FMRC Tennis Sisters | 0 | 14 | |
| 1331 | Gold | Gulf Harbour A Team | 0 | 13 | |
| 1332 | Gold | Gulf Harbour NoStringsAttached | 0 | 15 | |
| 1121 | Gold | Heritage Palms Match Pointers | 0 | 16 | |
| 1122 | Gold | Heritage Palms Sweet Spots | 0 | 14 | |
| 982 | Gold | Kelly Greens | 12 | 13 | |
| 1123 | Gold | Landings | 0 | 16 | |
| 1197 | Gold | Legends | 0 | 15 | |
| 1315 | Gold | Lexington | 0 | 16 | |
| 1313 | Gold | Park Meadow | 0 | 15 | |
| 987 | Gold | Pelican Landing | 14 | 16 | |
| 1314 | Gold | Pelican Preserve | 0 | 16 | |
| 1187 | Platinum | CCYC | 0 | 13 | |
| 1305 | Platinum | Gulf Harbour | 0 | 13 | |
| 1306 | Platinum | Landings Buttshots | 0 | 15 | |
| 1307 | Platinum | Landings Power Surge | 0 | 16 | |
| 1336 | Platinum | Park Meadow Performance | 0 | 12 | |
| 1335 | Platinum | Paseo | 0 | 16 | |
| 1334 | Platinum | Plantation | 0 | 15 | |
| 1115 | Platinum | Vasari | 0 | 15 | |
| 1209 | Silver | Breckenridge | 0 | 14 | |
| 1344 | Silver | CCRHC | 0 | 15 | |
| 1210 | Silver | CCYC | 0 | 13 | |
| 1211 | Silver | Colonial | 0 | 14 | |
| 1212 | Silver | Crown Colony | 0 | 11 | |
| 1213 | Silver | Del Tura | 0 | 16 | |
| 1345 | Silver | Dunes | 0 | 14 | |
| 1346 | Silver | Estero at the Vines | 0 | 16 | |
| 1215 | Silver | Fiddlesticks | 0 | 11 | |
| 1218 | Silver | Gulf Harbour Silver Belles | 0 | 15 | |
| 1219 | Silver | Gulf Harbour Silver Strings | 0 | 14 | |
| 1220 | Silver | Heritage Cove | 0 | 9 | |
| 1221 | Silver | Heritage Palms | 0 | 16 | |
| 1222 | Silver | Herons Glen | 0 | 11 | |
| 1223 | Silver | Judd Park | 0 | 13 | |
| 1225 | Silver | Landings Lucky Ladies | 0 | 16 | |
| 1226 | Silver | Landings Silver Stars | 0 | 14 | |
| 1227 | Silver | Legends | 0 | 16 | |
| 1228 | Silver | Lexington | 0 | 16 | |
| 1231 | Silver | Pelican Landing A | 0 | 14 | |
| 1316 | Silver | Pelican Landing Bobcats | 0 | 15 | |
| 1233 | Silver | Pelican Sound | 0 | 16 | |
| 1347 | Silver | Plantation | 0 | 16 | |
| 1317 | Silver | Rutenberg | 0 | 13 | |
| 1348 | Silver | Seven Lakes | 0 | 13 | |
| 1318 | Silver | Verandah | 0 | 16 | |