USP_SIMPLEDATALIST_COURSEGRADING

CREATE procedure dbo.USP_SIMPLEDATALIST_COURSEGRADING
(
    @COURSEID uniqueidentifier,
    @SESSIONSTARTDATE date,
    @SESSIONENDDATE date
)
as
    set nocount on;

    select COURSEGRADING.ID as VALUE,
           ACADEMICYEARNAMECODE.DESCRIPTION + ' ' + SESSIONNAMECODE.DESCRIPTION as LABEL
    from dbo.V_COURSEGRADING as COURSEGRADING
    join dbo.COURSE on COURSEGRADING.COURSEID = COURSE.ID
    join dbo.SESSION on dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, COURSEGRADING.STARTDATE, COURSEGRADING.ENDDATE) = SESSION.ID
    join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
    join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
    join dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
    where COURSEGRADING.COURSEID = @COURSEID and COURSEGRADING.STARTDATE = @SESSIONSTARTDATE and COURSEGRADING.ENDDATE = @SESSIONENDDATE
    order by COURSEGRADING.STARTDATE