USP_SIMPLEDATALIST_PROMOTESTUDENTSACADEMICYEAR

                create procedure dbo.USP_SIMPLEDATALIST_PROMOTESTUDENTSACADEMICYEAR
                (
                    @SCHOOLID uniqueidentifier = null,
                    @ACADEMICYEARID 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) and (ACADEMICYEAR.ID <> @ACADEMICYEARID)
                    order by ACADEMICYEAR.STARTDATE