UFN_ACADEMICYEAR_GETNEXT

create function dbo.UFN_ACADEMICYEAR_GETNEXT
(
    @DATE date,
    @SCHOOLID uniqueidentifier
)
returns uniqueidentifier
as
begin
    declare @ACADEMICYEARID uniqueidentifier

    select TOP 1 @ACADEMICYEARID = ACADEMICYEAR.ID
                    from dbo.ACADEMICYEAR
                    where STARTDATE>@DATE AND SCHOOLID=@SCHOOLID
                    order by STARTDATE asc

    return @ACADEMICYEARID
end