select distinct
* from
D_TH_Schedules_TX_XXXXXX_hrm
union all



select distinct
 SCHD_STU_COURSE.DISTRICT as 'DistrictID', RTRIM(SCHD_MS.BUILDING) as 'CampusID', RTRIM(SCHD_STU_COURSE.STUDENT_ID) as 'StudentID',	--01/08/2019 lt
 RTRIM(COURSE)  as 'Code', REPLACE(REPLACE(REPLACE(REPLACE(SCHD_MS.DESCRIPTION,',',' ') , ':',' '),'.', ' '),'&', 'AND')

as 'LocalName', RTRIM(START_PERIOD) as 'Period', RTRIM(ROOM_ID) as 'Room'	

from SCHD_STU_COURSE 

left join SCHD_MS on SCHD_MS.SECTION_KEY=SCHD_STU_COURSE.SECTION_KEY
left join SCHD_MS_SESSION on SCHD_MS_SESSION.SECTION_KEY=SCHD_STU_COURSE.SECTION_KEY
left join MR_STU_MP ON MR_STU_MP.SECTION_KEY=SCHD_STU_COURSE.SECTION_KEY AND SCHD_STU_COURSE.STUDENT_ID=MR_STU_MP.STUDENT_ID
left join REG_MP_DATES  ON SCHD_MS.BUILDING=REG_MP_DATES.BUILDING AND MR_STU_MP.MARKING_PERIOD=REG_MP_DATES.MARKING_PERIOD/*01/08/2019 lt 

where SCHOOL_YEAR=(select SCHOOL_YEAR from REG_DISTRICT where DISTRICT='XXXXX') AND MR_STU_MP.MARKING_PERIOD IN

(select distinct

MARKING_PERIOD FROM

REG_MP_DATES


where SCHOOL_YEAR=(select SCHOOL_YEAR from REG_DISTRICT where DISTRICT='XXXXXX') AND GETDATE() between [START_DATE] AND [END_DATE])*/

where SCHD_MS.SCHOOL_YEAR=(select SCHOOL_YEAR from REG_DISTRICT where DISTRICT='101919')
and  GETDATE() between [START_DATE] AND [END_DATE]