USP_SIMPLEDATALIST_SESSION_NAMECODE

CREATE procedure dbo.USP_SIMPLEDATALIST_SESSION_NAMECODE
(
    @ACADEMICYEARNAMECODEID uniqueidentifier = null
)
as
    select
        T.VALUE,
        T.LABEL
    from
        (select
            SESSIONNAMECODE.ID as VALUE, 
            SESSIONNAMECODE.DESCRIPTION as LABEL,
            TERM.STARTDATE,
            ROW_NUMBER() over (partition by SESSIONNAMECODE.ID order by TERM.STARTDATE) as ROW
        from dbo.ACADEMICYEAR
            inner join dbo.SESSION on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
            inner join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
            inner join dbo.TERM on SESSION.ID = TERM.SESSIONID
        where (
            @ACADEMICYEARNAMECODEID is null or
            @ACADEMICYEARNAMECODEID = '00000000-0000-0000-0000-000000000000' or
            ACADEMICYEARNAMECODEID = @ACADEMICYEARNAMECODEID
        )) T
    where T.ROW = 1
    order by T.STARTDATE