UFN_RELATIONSHIP_MATCHINGGIFTRELATIONSHIPCOUNT

Returns the number of relationships between a constituent and the reciprocal that are matching gift relationships.

Return

Return Type
int

Parameters

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

Definition

Copy



            create function dbo.UFN_RELATIONSHIP_MATCHINGGIFTRELATIONSHIPCOUNT(@RELATIONSHIPCONSTITUENTID uniqueidentifier, @RECIPROCALCONSTITUENTID uniqueidentifier)
            returns int
            as begin
                return (
                    select
                        count(ID)
                    from
                        dbo.RELATIONSHIP
                    where
                        RELATIONSHIPCONSTITUENTID = @RELATIONSHIPCONSTITUENTID and
                        RECIPROCALCONSTITUENTID = @RECIPROCALCONSTITUENTID and
                        ISMATCHINGGIFTRELATIONSHIP = 1)
            end