UFN_SCHOOLGRADELEVEL_GETNAME

                create function dbo.UFN_SCHOOLGRADELEVEL_GETNAME(@ID uniqueidentifier) returns nvarchar(10) 
                as
                begin
                    declare @s nvarchar(10);

                    select @s = 
                        dbo.GRADELEVEL.ABBREVIATION
                        from dbo.SCHOOLGRADELEVEL 
                        inner join dbo.GRADELEVEL on dbo.SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
                        where dbo.SCHOOLGRADELEVEL.ID = @ID;

                    return @s;
                end