USP_SIMPLEDATALIST_CONSTITUENTRELATIONSHIPRECIPROCALCONSTITUENT

                CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTRELATIONSHIPRECIPROCALCONSTITUENT(@CONSTITUENTID uniqueidentifier)
                as
                    set nocount on;

                    select    
                        CONSTITUENT.ID VALUE,
                        NF.NAME LABEL
                    from 
                        dbo.RELATIONSHIP 
                        inner join dbo.CONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONSTITUENT.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                    where 
                        RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                    order by
                        CONSTITUENT.KEYNAME, 2