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 | |
| 989 | 3.0 | Breckenridge | 13 | 14 | |
| 1106 | 3.0 | CCYC | 0 | 12 | |
| 990 | 3.0 | Colonial | 11 | 16 | |
| 1180 | 3.0 | Crown Colony | 0 | 16 | |
| 994 | 3.0 | Del Tura Aces | 10 | 13 | |
| 993 | 3.0 | Del Tura Angels | 10 | 13 | |
| 1171 | 3.0 | Fiddlesticks | 0 | 13 | |
| 1172 | 3.0 | FMRC | 0 | 16 | |
| 1173 | 3.0 | Gateway | 0 | 16 | |
| 1107 | 3.0 | Heritage Palms | 0 | 16 | |
| 1003 | 3.0 | Herons Glen | 14 | 16 | |
| 1004 | 3.0 | Kelly Greens | 12 | 14 | |
| 1176 | 3.0 | Landings Alley Cats | 0 | 12 | |
| 1007 | 3.0 | Legends | 14 | 16 | |
| 1174 | 3.0 | Lexington Matchmakers | 0 | 16 | |
| 1175 | 3.0 | Lexington Racq Pacq | 0 | 15 | |
| 1263 | 3.0 | Mid-Cape | 0 | 15 | |
| 1177 | 3.0 | Miromar Lakes | 0 | 13 | |
| 1178 | 3.0 | Park Meadow | 0 | 16 | |
| 1179 | 3.0 | Pelican Landing | 0 | 16 | |
| 1010 | 3.0 | Rutenberg | 13 | 16 | |
| 1181 | 3.0 Minus | Breckenridge Hot Shots | 0 | 11 | |
| 1182 | 3.0 Minus | Breckenridge Sling Shots | 0 | 16 | |
| 1183 | 3.0 Minus | CCYC | 0 | 13 | |
| 1109 | 3.0 Minus | Cross Creek Estates | 0 | 16 | |
| 1184 | 3.0 Minus | Landings Lucky Ladies | 0 | 14 | |
| 1185 | 3.0 Minus | Landings Originals | 0 | 16 | |
| 1186 | 3.0 Minus | Lexington Net Returns | 0 | 16 | |
| 1011 | 3.5 | Breckenridge | 12 | 14 | |
| 1073 | 3.5 | CCYC | 11 | 13 | |
| 1247 | 3.5 | Del Tura | 0 | 12 | |
| 1015 | 3.5 | Fiddlesticks | 11 | 13 | |
| 1248 | 3.5 | FMRC Just 4 Fun | 0 | 12 | |
| 1017 | 3.5 | Gateway | 13 | 14 | |
| 1249 | 3.5 | Gulf Harbour | 0 | 16 | |
| 1019 | 3.5 | Herons Glen | 13 | 15 | |
| 1080 | 3.5 | Kelly Greens | 13 | 15 | |
| 1250 | 3.5 | Landings Happy Feet | 0 | 12 | |
| 1251 | 3.5 | Landings Netchix | 0 | 13 | |
| 1023 | 3.5 | Legends | 12 | 15 | |
| 1082 | 3.5 | Mid-Cape | 10 | 13 | |
| 1252 | 3.5 | Park Meadow | 0 | 12 | |
| 1253 | 3.5 | Pelican Preserve | 0 | 15 | |
| 1254 | 3.5 | Rutenberg | 0 | 12 | |
| 1155 | 3.5 Minus | Breckenridge | 0 | 13 | |
| 1152 | 3.5 Minus | CCYC | 0 | 12 | |
| 1153 | 3.5 Minus | Dunes | 0 | 12 | |
| 1255 | 3.5 Minus | Estero At the Vines | 0 | 15 | |
| 1169 | 3.5 Minus | FMRC | 0 | 13 | |
| 1256 | 3.5 Minus | Forest | 0 | 15 | |
| 1257 | 3.5 Minus | Gulf Harbour | 0 | 16 | |
| 1168 | 3.5 Minus | Heritage Palms Glam Slams | 0 | 12 | |
| 1161 | 3.5 Minus | Heritage Palms Racquettes | 0 | 13 | |
| 1165 | 3.5 Minus | Herons Glen | 0 | 10 | |
| 1167 | 3.5 Minus | Judd Park | 0 | 13 | |
| 1258 | 3.5 Minus | Landings Gems | 0 | 12 | |
| 1160 | 3.5 Minus | Landings Wildcats | 0 | 11 | |
| 1154 | 3.5 Minus | Legends | 0 | 15 | |
| 1151 | 3.5 Minus | Lexington Alligettors | 0 | 16 | |
| 1259 | 3.5 Minus | Lexington Claymates | 0 | 15 | |
| 1159 | 3.5 Minus | Park Meadow Racquettes | 0 | 15 | |
| 1158 | 3.5 Minus | Pelican Landing | 0 | 14 | |
| 941 | 4.0 | Beachview | 12 | 13 | |
| 1066 | 4.0 | Dunes | 0 | 12 | |
| 1069 | 4.0 | Gulf Harbour | 0 | 15 | |
| 1240 | 4.0 | HP Poachers | 0 | 11 | |
| 1070 | 4.0 | Park Meadow | 0 | 13 | |
| 1241 | 4.0 | Paseo | 0 | 12 | |
| 1242 | 4.0 Minus | Bonita Bay | 0 | 16 | |
| 1244 | 4.0 Minus | FMRC Blu Cru | 0 | 14 | |
| 1245 | 4.0 Minus | Gulf Harbour | 0 | 16 | |
| 903 | 4.0 Minus | Landings | 11 | 15 | |
| 904 | 4.0 Minus | Legends | 11 | 14 | |
| 1246 | 4.0 Minus | Lexington BBs | 0 | 15 | |
| 906 | 4.0 Minus | Lexington Racquettes | 11 | 12 | |
| 908 | 4.0 Minus | Park Meadow | 9 | 13 | |
| 1199 | 60 Plus | Breckenridge | 0 | 12 | |
| 1200 | 60 Plus | Landings | 0 | 14 | |
| 921 | 60 Plus | Legends | 14 | 15 | |
| 924 | 60 Plus | Sabal Springs | 10 | 12 | |
| 1201 | Bronze | Breckenridge Overheads | 0 | 13 | |
| 1202 | Bronze | Breckenridge Racqueteers | 0 | 13 | |
| 1203 | Bronze | Colonial | 0 | 14 | |
| 1136 | Bronze | Cross Creek Estates | 0 | 15 | |
| 911 | Bronze | Del Tura | 11 | 15 | |
| 1138 | Bronze | Dunes | 0 | 11 | |
| 1139 | Bronze | Estero at the Vines | 0 | 11 | |
| 1204 | Bronze | Heritage Palms | 0 | 15 | |
| 1140 | Bronze | Kelly Greens | 11 | 13 | |
| 913 | Bronze | Landings | 14 | 15 | |
| 914 | Bronze | Legends | 15 | 16 | |
| 1205 | Bronze | Lexington | 0 | 16 | |
| 1141 | Bronze | Pelican Landing | 0 | 16 | |
| 1206 | Bronze | Rutenberg | 0 | 13 | |
| 1207 | Bronze | Seven Lakes | 0 | 12 | |
| 1142 | Bronze | Verandah | 0 | 15 | |
| 1235 | Dynamo | CCYC | 0 | 12 | |
| 937 | Dynamo | Landings | 15 | 16 | |
| 1064 | Dynamo | Paseo | 0 | 15 | |
| 1239 | Dynamo | PM AAs | 0 | 13 | |
| 1238 | Dynamo | PM Sweet Spots | 0 | 14 | |
| 1237 | Dynamo | PM Tennis Junkies | 0 | 13 | |
| 972 | Gold | Breckenridge | 12 | 15 | |
| 1194 | Gold | CCYC | 0 | 14 | |
| 976 | Gold | Fiddlesticks | 13 | 15 | |
| 1195 | Gold | FMRC Ace Cadettes | 0 | 15 | |
| 1196 | Gold | FMRC Golden Gals | 0 | 13 | |
| 977 | Gold | Forest | 13 | 15 | |
| 1120 | Gold | Gateway | 0 | 13 | |
| 979 | Gold | Gulf Harbour | 13 | 16 | |
| 1121 | Gold | Heritage Palms Match Pointers | 0 | 13 | |
| 1122 | Gold | Heritage Palms Sweet Spots | 0 | 11 | |
| 981 | Gold | Herons Glen | 11 | 15 | |
| 982 | Gold | Kelly Greens | 12 | 13 | |
| 1123 | Gold | Landings | 0 | 16 | |
| 1197 | Gold | Legends | 0 | 14 | |
| 1124 | Gold | Lexington Daisies | 0 | 13 | |
| 1125 | Gold | Lexington Racqueteers | 0 | 12 | |
| 1126 | Gold | Mid-Cape | 0 | 13 | |
| 1187 | Platinum | CCYC | 0 | 12 | |
| 1188 | Platinum | Landings Classics | 0 | 16 | |
| 1189 | Platinum | Landings Newbies | 0 | 15 | |
| 1190 | Platinum | Park Meadow JK | 0 | 14 | |
| 1191 | Platinum | Park Meadow Performance | 0 | 14 | |
| 1192 | Platinum | Paseo Panthers | 0 | 13 | |
| 1193 | Platinum | Paseo Power | 0 | 12 | |
| 895 | Platinum | Pelican Landing | 15 | 16 | |
| 1115 | Platinum | Vasari | 0 | 16 | |
| 1209 | Silver | Breckenridge | 0 | 15 | |
| 1210 | Silver | CCYC | 0 | 15 | |
| 1211 | Silver | Colonial | 0 | 13 | |
| 1212 | Silver | Crown Colony | 0 | 15 | |
| 1213 | Silver | Del Tura | 0 | 14 | |
| 1261 | Silver | Estero At the Vines | 0 | 15 | |
| 1215 | Silver | Fiddlesticks | 0 | 12 | |
| 1216 | Silver | FMRC | 0 | 14 | |
| 1217 | Silver | Forest | 0 | 16 | |
| 1218 | Silver | Gulf Harbour Silver Belles | 0 | 16 | |
| 1219 | Silver | Gulf Harbour Silver Strings | 0 | 16 | |
| 1220 | Silver | Heritage Cove | 0 | 12 | |
| 1221 | Silver | Heritage Palms | 0 | 16 | |
| 1222 | Silver | Herons Glen | 0 | 16 | |
| 1223 | Silver | Judd Park | 0 | 14 | |
| 1224 | Silver | Kelly Greens | 0 | 12 | |
| 1225 | Silver | Landings Lucky Ladies | 0 | 14 | |
| 1226 | Silver | Landings Silver Stars | 0 | 14 | |
| 1227 | Silver | Legends | 0 | 14 | |
| 1228 | Silver | Lexington | 0 | 15 | |
| 1229 | Silver | Mid-Cape | 0 | 14 | |
| 1230 | Silver | Park Meadow | 0 | 16 | |
| 1231 | Silver | Pelican Landing A | 0 | 14 | |
| 1232 | Silver | Pelican Landing B | 0 | 16 | |
| 1234 | Silver | Pelican Preserve | 0 | 14 | |
| 1233 | Silver | Pelican Sound | 0 | 16 | |