UFN_INTERACTION_ISADDITIONALFUNDRAISER

Returns true if the constituent is an additional fundraiser for the interaction.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_INTERACTION_ISADDITIONALFUNDRAISER
            (
                @INTERACTIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns bit
            with execute as caller
            as
            begin
                declare @RETURNVALUE as bit
                if exists (select ID from dbo.INTERACTIONADDITIONALFUNDRAISER where INTERACTIONID = @INTERACTIONID and FUNDRAISERID = @CONSTITUENTID)
                    select @RETURNVALUE = 1
                else
                    select @RETURNVALUE = 0

                return @RETURNVALUE
            end