USP_SIMPLEDATALIST_CLASSADD_TERM

CREATE procedure dbo.USP_SIMPLEDATALIST_CLASSADD_TERM
(
    @COURSEID uniqueidentifier = null,
    @SESSIONID uniqueidentifier = null
)
as
    select 
        TERM.ID as VALUE, 
        DESCRIPTION as LABEL
    from dbo.V_COURSERESTRICTION as COURSERESTRICTION 
        inner join dbo.COURSERESTRICTIONSTARTTERM on COURSERESTRICTION.ID = COURSERESTRICTIONSTARTTERM.COURSERESTRICTIONID
        inner join dbo.TERM on TERM.STARTDATE = COURSERESTRICTIONSTARTTERM.STARTDATE
            and TERM.ENDDATE = COURSERESTRICTIONSTARTTERM.ENDDATE
        inner join dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
    where TERM.SESSIONID = @SESSIONID
        and COURSERESTRICTION.COURSEID = @COURSEID
    order by COURSERESTRICTIONSTARTTERM.STARTDATE