USP_BBNC_GETSPOUSE

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

        select
            RECIPROCALCONSTITUENTID as SPOUSE_CONSTITUENTID
            from
                dbo.RELATIONSHIP
            where
                RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                and RELATIONSHIP.ISSPOUSE = 1