UFN_RESOURCE_GETNAME

            CREATE function dbo.UFN_RESOURCE_GETNAME
                (
                    @ID uniqueidentifier
                ) 
            returns nvarchar(100) 
            as
            begin
                declare @NAME nvarchar(100);
                select @NAME = NAME from dbo.RESOURCE where ID = @ID;
                return @NAME;
            end