USP_SIMPLEDATALIST_COURSE_CURRENTSESSION_CYCLEDAY

CREATE procedure dbo.USP_SIMPLEDATALIST_COURSE_CURRENTSESSION_CYCLEDAY
(
    @ID uniqueidentifier = null
)
as
    set nocount on;

    declare @CURRENTDATE date = getdate()

    select
        CYCLEDAY.ID as VALUE,
        CYCLEDAY.DESCRIPTION as LABEL
    from dbo.COURSE
        inner join dbo.SESSION on dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, @CURRENTDATE, @CURRENTDATE) = SESSION.ID
        inner join dbo.TIMETABLE on SESSION.TIMETABLEID = TIMETABLE.ID
        inner join dbo.CYCLEDAY on TIMETABLE.CYCLEID = CYCLEDAY.CYCLEID
    where COURSE.ID = @ID
    group by CYCLEDAY.ID, CYCLEDAY.DESCRIPTION, CYCLEDAY.SEQUENCE
    order by CYCLEDAY.SEQUENCE asc