UFN_ACADEMICYEAR_GETCURRENT

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

    select @ACADEMICYEARID = ACADEMICYEAR.ID
                    from dbo.ACADEMICYEAR
                    where STARTDATE<=@DATE AND ENDDATE>=@DATE AND SCHOOLID=@SCHOOLID

    return @ACADEMICYEARID
end