UFN_RELATIONSHIP_GETNAME

                CREATE function dbo.UFN_RELATIONSHIP_GETNAME(@ID uniqueidentifier)
                returns nvarchar(100)
                with execute as caller
                as
                begin
                    return
                    (
                        select RELATIONSHIPTYPECODE.DESCRIPTION
                        from dbo.RELATIONSHIPTYPECODE
                        where ID = (select RELATIONSHIPTYPECODEID from dbo.RELATIONSHIP where RELATIONSHIP.ID = @ID)
                    )
                end