USP_SIMPLEDATALIST_SESSION

CREATE procedure dbo.USP_SIMPLEDATALIST_SESSION
(
    @ACADEMICYEARID uniqueidentifier = null
)
as
    select
        T.VALUE,
        T.LABEL
    from
        (select 
            SESSION.ID as VALUE, 
            DESCRIPTION as LABEL,
            TERM.STARTDATE,
            ROW_NUMBER() over (partition by SESSION.ID order by TERM.STARTDATE) as ROW
        from dbo.SESSION
            inner join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
            inner join dbo.TERM on SESSION.ID = TERM.SESSIONID
        where ACADEMICYEARID = @ACADEMICYEARID) T
    where T.ROW = 1
    order by T.STARTDATE