UFN_RELATIONSHIP_DESCRIPTION

                CREATE function dbo.UFN_RELATIONSHIP_DESCRIPTION(@ID uniqueidentifier)
                returns nvarchar(700) 
                with execute as caller
                as begin
                    return (
                        select    
                            NF.NAME + ' - ' + dbo.UFN_RELATIONSHIPTYPECODE_GETDESCRIPTION(RELATIONSHIP.RECIPROCALTYPECODEID)
                        from 
                            dbo.RELATIONSHIP 
                            inner join dbo.CONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONSTITUENT.ID
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                        where 
                            RELATIONSHIP.ID = @ID
                    );
                end