UFN_CONSTITUENT_CONTACTRELATIONSHIP

                CREATE function dbo.UFN_CONSTITUENT_CONTACTRELATIONSHIP
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(700) 
                with execute as caller
                as begin
                    return (
                        select    
                            NF.NAME + ' - ' + dbo.UFN_CONTACTTYPECODE_GETDESCRIPTION(RELATIONSHIP.CONTACTTYPECODEID)
                        from 
                            dbo.RELATIONSHIP
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(RELATIONSHIP.RECIPROCALCONSTITUENTID) NF
                        where 
                            RELATIONSHIP.ID = @ID
                    );
                end