USP_SIMPLEDATALIST_CONSTITUENTCONTACTRELATIONSHIP

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

                    select
                        RELATIONSHIP.ID as VALUE,
                        NF.NAME + ' - ' + (select DESCRIPTION from dbo.CONTACTTYPECODE where ID = RELATIONSHIP.CONTACTTYPECODEID) as LABEL
                    from 
                        dbo.RELATIONSHIP
                        inner join dbo.CONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONSTITUENT.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                    where
                        RELATIONSHIP.ISCONTACT = 1 and 
                        RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                    order by
                        CONSTITUENT.KEYNAME, 2;