USP_SIMPLEDATALIST_ACADEMICYEAR_NAMECODE

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