Timetrial League Standings for 2024

Quarterly Prizes

 First Quarter Winner (Jan-Mar)  R200 
 Second Quarter Winner (Apr-Jun)  R200 
 Third Quarter Winner (Jul-Oct)  R200 
 Fourth Quarter Winner (Nov-Dec)  R200 

Annual Prizes

 Winner  R400 
 Second Place  R250 
 Third Place  R150 

Please Note : Only club members are eligible for prizes. Members are in red; non-members are in black.

If you are a member but do not appear here in red, please contact a committee member.

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1627 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1627 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1627 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 1 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1623 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1623 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1623 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 2 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1631 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1631 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1631 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 3 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1626 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1626 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1626 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 4 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 5 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 6 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1629 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1629 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1629 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 7 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1628 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1628 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1628 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 8 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 887 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 887 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 887 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 9 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 10 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 11 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 12 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 13 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1508 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1508 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1508 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 14 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 15 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 16 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 17 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 18 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 19 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 20 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 21 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 22 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 23 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test - Iteration 24 , Time 2024/05/30 18:50:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 25 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 26 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 27 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 28 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 29 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 30 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 31 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 32 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 33 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 34 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 90 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 90 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 90 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 35 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 94 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 94 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 94 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 36 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 952 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 952 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 952 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 37 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1118 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1118 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1118 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 38 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 39 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 40 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 41 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 42 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 43 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 44 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.01 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 45 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.01 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.01 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 46 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 47 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 48 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 49 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 50 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 51 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 52 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 53 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1624 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1624 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1624 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 54 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 55 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 56 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 57 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 58 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 59 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 60 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 61 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 62 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 63 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 64 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 650 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 650 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 650 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 65 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.01 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 66 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 67 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 68 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 69 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 70 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 71 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 72 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 73 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 74 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 75 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 76 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 77 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 78 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 79 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 80 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 81 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 82 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 83 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 84 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 85 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 86 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 87 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1612 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1612 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1612 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 88 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 458 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 458 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 458 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 89 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 458 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 458 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 458 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 90 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 91 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 92 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 93 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 94 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 95 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 651 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 651 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 651 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 96 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1620 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.01 AND cr_cp_key = 1620 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1620 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 97 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 98 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 99 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 100 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 101 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 102 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 103 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 104 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 105 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 106 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 107 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 108 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 109 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 110 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 111 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 112 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 113 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 114 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 115 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 116 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 117 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 560 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 560 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 560 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 118 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 119 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 120 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 121 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 122 , Time 2024/05/30 18:50:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1630 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1630 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) - 732 AND CONVERT(DATETIME, '05/01/2024', 101) - 1 , Time 2024/05/30 18:50:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1630 AND cd_date BETWEEN CONVERT(DATETIME, '05/01/2024', 101) AND CONVERT(DATETIME, '06/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/05/30 18:50:15

Test - Iteration 123 , Time 2024/05/30 18:50:15complete



January  2024

NamePoints
Craig Inggs8
David Lamont5
Keenan Clothier4
Craig Fowels4
Karen Inggs3
Fred Schoon3
Jennifer Sutton3
Mike Sutton3
Martin Birtwhistle2
Sandra Conway2
Leona Lamont2
Steve Conway1
Owethi Ntuli1
Zama Cele1
Kelly Schoon1
Simone Schoon1
Susan Schoon1
Marguerite Labuschagne1
Shane Govender1
Johannes Van Eden1
Odette Wheeler1


February  2024

NamePoints
Keenan Clothier4
Sandra Conway4
Craig Inggs4
Karen Inggs4
David Lamont4
Leona Lamont4
Fred Schoon4
Steve Conway3
Susan Schoon3
Donovan Snodgrass3
Jennifer Sutton3
Mike Sutton3
Zama Cele2
Craig Fowels2
Shane Govender2
Jan Van Eden2
Odette Wheeler2
Asante .1
Derek Gace1
Sihle Lange1
Hazel Gace1
Cyril .1
Garth Hancock1
Thérèse Hurly1
Francois De Villiers1
Ruth De Villiers1
Marguerite Labuschagne1


March  2024

NamePoints
Keenan Clothier3
Craig Fowels3
Derek Gace3
Hazel Gace3
David Lamont3
Fred Schoon3
Susan Schoon3
Zara Hardy2
Craig Inggs2
Karen Inggs2
Zama Cele2
Leona Lamont2
Sandra Conway2
Steve Conway2
Jan Van Eden2
Odette Wheeler2
Susan Ferencak1
Mike Sutton1
Sihle Lange1
Martin Birtwhistle1


Quarter 1

NamePoints
Craig Inggs14
David Lamont12
Keenan Clothier11
Fred Schoon10
Craig Fowels9
Karen Inggs9
Leona Lamont8
Sandra Conway8
Susan Schoon7
Mike Sutton7
Jennifer Sutton6
Steve Conway6
Zama Cele5
Odette Wheeler5
Hazel Gace4
Jan Van Eden4
Derek Gace4
Shane Govender3
Donovan Snodgrass3
Martin Birtwhistle3
Marguerite Labuschagne2
Sihle Lange2
Zara Hardy2
Owethi Ntuli1
Thérèse Hurly1
Kelly Schoon1
Simone Schoon1
Cyril .1
Asante .1
Francois De Villiers1
Ruth De Villiers1
Garth Hancock1
Johannes Van Eden1
Susan Ferencak1

April  2024

NamePoints
Craig Inggs8
Sandra Conway7
Karen Inggs7
Mike Sutton6
Craig Fowels4
David Lamont4
Leona Lamont4
Fred Schoon4
Steve Conway4
Lily Ngcobo3
Keenan Clothier3
Susan Schoon3
Donovan Snodgrass3
Martin Birtwhistle3
Jan Van Eden3
Zama Cele2
Derek Gace2
Cyril .1
Zara .1
Marguerite Labuschagne1
Andrew .1
Matthew Ferencak1
Sandy Byleveld1
Kalman Porritt1
Charmaine .1
Hazel Gace1
Garth Hancock1
Craig Holtzhausen1
Thérèse Hurly1


May  2024

NamePoints
Jan Van Eden8
Steve Conway4
Karen Inggs4
Fred Schoon4
Susan Schoon4
Sandra Conway4
David Lamont3
Craig Inggs3
Craig Fowels2
Leona Lamont2
Lily Ngcobo2
Craig Holtzhausen2
Martin Birtwhistle2
Donovan Snodgrass2
Keenan Clothier2
Shane .1
Thérèse Hurly1
Kalman Porritt1
Jenny Birtwhistle1
Jessica Inggs1
Bonga .1
Jennifer Sutton1
Mike Sutton1
Zama Cele1
Odette Wheeler1
Yvette Wheeler1


Quarter 2

NamePoints
Sandra Conway11
Craig Inggs11
Karen Inggs11
Jan Van Eden11
Fred Schoon8
Steve Conway8
Susan Schoon7
Mike Sutton7
David Lamont7
Craig Fowels6
Leona Lamont6
Martin Birtwhistle5
Donovan Snodgrass5
Lily Ngcobo5
Keenan Clothier5
Zama Cele3
Craig Holtzhausen3
Kalman Porritt2
Thérèse Hurly2
Derek Gace2
Bonga .1
Jessica Inggs1
Charmaine .1
Marguerite Labuschagne1
Cyril .1
Shane .1
Matthew Ferencak1
Zara .1
Jenny Birtwhistle1
Hazel Gace1
Garth Hancock1
Jennifer Sutton1
Andrew .1
Sandy Byleveld1
Odette Wheeler1
Yvette Wheeler1

Annual Scores

NamePoints
Craig Inggs25
Karen Inggs20
Sandra Conway19
David Lamont19
Fred Schoon18
Keenan Clothier16
Craig Fowels15
Jan Van Eden15
Steve Conway14
Susan Schoon14
Mike Sutton14
Leona Lamont14
Donovan Snodgrass8
Martin Birtwhistle8
Zama Cele8
Jennifer Sutton7
Derek Gace6
Odette Wheeler6
Lily Ngcobo5
Hazel Gace5
Craig Holtzhausen3
Marguerite Labuschagne3
Thérèse Hurly3
Shane Govender3
Sihle Lange2
Garth Hancock2
Kalman Porritt2
Zara Hardy2
Cyril .2
Matthew Ferencak1
Susan Ferencak1
Zara .1
Jenny Birtwhistle1
Asante .1
Owethi Ntuli1
Sandy Byleveld1
Bonga .1
Kelly Schoon1
Simone Schoon1
Charmaine .1
Andrew .1
Shane .1
Francois De Villiers1
Jessica Inggs1
Johannes Van Eden1
Ruth De Villiers1
Yvette Wheeler1


END OF LIST



Formula To Derive Monthly Scores :