UFN_DESIGNATIONGOAL_GETNAME

            CREATE function dbo.UFN_DESIGNATIONGOAL_GETNAME(@ID uniqueidentifier) returns nvarchar(100) WITH EXECUTE as CALLER
            as
            begin
                declare @NAME nvarchar(100);
                select @NAME = DESIGNATIONLEVELGOAL.NAME from dbo.DESIGNATIONLEVELGOAL 
                inner join dbo.DESIGNATIONGOAL on DESIGNATIONLEVELGOAL.ID = DESIGNATIONGOAL.DESIGNATIONLEVELGOALID
                where DESIGNATIONGOAL.ID = @ID
                return @NAME
            end