USP_SIMPLEDATALIST_CLASS_CYCLEDAY

create procedure dbo.USP_SIMPLEDATALIST_CLASS_CYCLEDAY
(
    @ID uniqueidentifier = null
)
as
    set nocount on

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