USP_SIMPLEDATALIST_ACADEMICYEAR_WITHOPTIONS

CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICYEAR_WITHOPTIONS
(
    @SCHOOLID uniqueidentifier = null
) as
select 
    YEARS.VALUE, YEARS.LABEL 
from
    (select 
        ACADEMICYEAR.ID as VALUE, 
        ACADEMICYEARNAMECODE.DESCRIPTION as LABEL,
        2 as SEQUENCE
    from dbo.ACADEMICYEAR
    inner join dbo.ACADEMICYEARNAMECODE 
        on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
    where (SCHOOLID = @SCHOOLID) or (@SCHOOLID is null)

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

    ) YEARS 
order by SEQUENCE, LABEL