UFN_DESIGNATIONLEVELGOAL_GETNAME

            CREATE function dbo.UFN_DESIGNATIONLEVELGOAL_GETNAME(@ID uniqueidentifier) returns nvarchar(100) WITH EXECUTE as CALLER
            as
            begin
                declare @NAME nvarchar(100);
                select @NAME = NAME from dbo.DESIGNATIONLEVELGOAL where ID = @ID
                return @NAME
            end