ALTER FUNCTION [dbo].[fGetDataObjectTitle] (@guid AS UNIQUEIDENTIFIER) 
RETURNS VARCHAR(1000) AS 
BEGIN 
	DECLARE @sql AS NVARCHAR (2000), @DataObjectTypeId UNIQUEIDENTIFIER, @DataTableName NVARCHAR(200), @Title NVARCHAR (1000), @Result NVARCHAR(1000)

	SELECT TOP 1 @DataTableName = dt.SQLName, @Title = CASE WHEN dtf1.IsFriendlyName = 1 THEN dtf1.SQLName ELSE dtf2.SQLName END
	FROM tblDataObject dob
	JOIN tblDataObjectType dot ON dot.guid = dob.DataObjectTypeId
	JOIN tblDataTable dt ON dt.guid = dot.DataTableId
	LEFT JOIN tblDataTableField dtf1 ON dtf1.DataTableId = dt.guid AND dtf1.IsFriendlyName = 1
	LEFT JOIN tblDataTableField dtf2 ON dtf2.DataTableId = dt.guid AND dtf2.SQLName = 'Title'
	WHERE dob.guid = @guid

	IF @DataTableName IS NULL OR @Title IS NULL 
		RETURN ''

	SET @sql = ' SELECT @Result = ' + @Title + ' FROM ' + @DataTableName + ' WHERE DataObjectId = @guid '

	EXEC sp_executesql @sql,  N'@guid uniqueidentifier, @Result NVARCHAR (1000) OUT',  @guid = @guid, @Result=@Result OUT

	RETURN @Result
END