USP_SIMPLEDATALIST_ACADEMICYEAR

                CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICYEAR
                (
                    @SCHOOLID uniqueidentifier = null
                ) as
                    select 
                        ACADEMICYEAR.ID as VALUE, 
                        ACADEMICYEARNAMECODE.DESCRIPTION as LABEL
                    from dbo.ACADEMICYEAR
                    inner join dbo.ACADEMICYEARNAMECODE 
                        on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
                    where (SCHOOLID = @SCHOOLID)
                    order by ACADEMICYEAR.STARTDATE