2024-2025 Season
Fall Schedule - query
RESULTSET
Fall Schedule - query
  CITY COLLEGE_TOURNAMENT_SITE COURSE_DESCR EVENT_DESCRIPTION EVENT_END_DATE EVENT_ID EVENT_PAGE_ACTIVE EVENT_START_DATE RANKING_CD SCHEDULE_COMMENT SHOW_FIELD SHOW_TEE_TIMES STATE_CD
CACHED false
EXECUTIONTIME 2
SQL declare @year int, @season varchar(10) set @year = ? set @season = ? select distinct te.event_id , te.event_description , te.event_start_date , te.event_end_date , schedule_comment , te.show_field , te.show_tee_times , te.college_tournament_site , te.event_page_active , te.ranking_cd , c.course_descr , a.city , a.state_cd from tournament t inner join tournament_event te on te.event_id = t.event_id inner join course c on c.course_id = t.tournament_site_course_id inner join address a on a.address_id = c.course_address_id where te.event_start_date between '8/1/2024' and '12/31/2024' order by te.event_start_date
SQLPARAMETERS
Fall Schedule - array
1 2024
2 fall
Spring Schedule - query
RESULTSET
Spring Schedule - query
  CITY COLLEGE_TOURNAMENT_SITE COURSE_DESCR EVENT_DESCRIPTION EVENT_END_DATE EVENT_ID EVENT_PAGE_ACTIVE EVENT_START_DATE RANKING_CD SCHEDULE_COMMENT SHOW_FIELD SHOW_TEE_TIMES STATE_CD
CACHED false
EXECUTIONTIME 8
SQL declare @year int, @season varchar(10) set @year = ? set @season = ? select distinct te.event_id , te.event_description , te.event_start_date , te.event_end_date , schedule_comment , te.show_field , te.show_tee_times , te.college_tournament_site , te.event_page_active , te.ranking_cd , c.course_descr , a.city , a.state_cd from tournament t inner join tournament_event te on te.event_id = t.event_id inner join course c on c.course_id = t.tournament_site_course_id inner join address a on a.address_id = c.course_address_id where te.event_start_date between '1/1/2025' and '7/31/2025' order by te.event_start_date
SQLPARAMETERS
Spring Schedule - array
1 2025
2 spring