USP_SIMPLEDATALIST_CONSTITUENTSRELATIONSHIPS

Returns the relationships that exist between two constituents.

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONSHIPCONSTITUENTID	uniqueidentifier	IN	Relationship constituent
@RECIPROCALCONSTITUENTID	uniqueidentifier	IN	Reciprocal constituent

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTSRELATIONSHIPS
                (
                    @RELATIONSHIPCONSTITUENTID uniqueidentifier,
                    @RECIPROCALCONSTITUENTID uniqueidentifier
                )
                as

                set nocount on;

                select
                    RELATIONSHIP.ID as VALUE,
                    dbo.UFN_RELATIONSHIP_GETNAME(RELATIONSHIP.ID) as LABEL
                from dbo.RELATIONSHIP
                where RELATIONSHIPCONSTITUENTID = @RELATIONSHIPCONSTITUENTID
                    and RECIPROCALCONSTITUENTID = @RECIPROCALCONSTITUENTID;