USP_SIMPLEDATALIST_SESSION_WITHOPTIONS

CREATE procedure dbo.USP_SIMPLEDATALIST_SESSION_WITHOPTIONS
(
    @ACADEMICYEARID uniqueidentifier = null
) as
select 
    SESSIONS.VALUE, SESSIONS.LABEL 
from
    (select 
        SESSION.ID as VALUE, 
        DESCRIPTION as LABEL,
        2 as SEQUENCE
    from dbo.SESSION
    inner join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
    where (ACADEMICYEARID = @ACADEMICYEARID)

    union 
    select
        '00000000-0000-0000-0000-000000000001' as VALUE,
        'This session' as LABEL,
        0 as SEQUENCE
    union 
    select
        '00000000-0000-0000-0000-000000000002' as VALUE,
        'Next session' as LABEL,
        1 as SEQUENCE

    ) SESSIONS 
order by SEQUENCE, LABEL