USP_SIMPLEDATALIST_RELATIONSHIP_IND2IND

This list returns all relationship between two constituents.

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONSHIPCONSTITUENTID	uniqueidentifier	IN
@RECIPROCALCONSTITUENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_RELATIONSHIP_IND2IND
(
    @RELATIONSHIPCONSTITUENTID uniqueidentifier,
    @RECIPROCALCONSTITUENTID uniqueidentifier
)
as
    select 
        RELATIONSHIP.ID as VALUE, 
        RELATIONSHIPCONSTITUENT.FIRSTNAME + ' (' +  RELATIONSHIPTYPECODE.DESCRIPTION + '), ' + RECIPROCALCONSTITUENT.FIRSTNAME + ' (' + RECIPROCALTYPECODE.DESCRIPTION + ')' as LABEL
    from dbo.RELATIONSHIP
    inner join dbo.CONSTITUENT RELATIONSHIPCONSTITUENT on RELATIONSHIP.RELATIONSHIPCONSTITUENTID = RELATIONSHIPCONSTITUENT.ID
    inner join dbo.CONSTITUENT RECIPROCALCONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = RECIPROCALCONSTITUENT.ID
    inner join dbo.RELATIONSHIPTYPECODE on RELATIONSHIP.RELATIONSHIPTYPECODEID = RELATIONSHIPTYPECODE.ID
    inner join dbo.RELATIONSHIPTYPECODE RECIPROCALTYPECODE on RELATIONSHIP.RECIPROCALTYPECODEID = RECIPROCALTYPECODE.ID
    where RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @RELATIONSHIPCONSTITUENTID and RELATIONSHIP.RECIPROCALCONSTITUENTID = @RECIPROCALCONSTITUENTID