UFN_ACADEMICYEAR_GETNAME

create function dbo.UFN_ACADEMICYEAR_GETNAME(@ACADEMICYEARID uniqueidentifier)
returns nvarchar(100)
with execute as caller
as begin

    -- do work here and return a value

    return (
        select 
            DESCRIPTION 
        from dbo.ACADEMICYEAR 
            join dbo.ACADEMICYEARNAMECODE on ACADEMICYEARNAMECODE.ID = ACADEMICYEAR.ACADEMICYEARNAMECODEID 
        where 
            ACADEMICYEAR.ID = @ACADEMICYEARID )

end