UFN_CONSTITUENT_GETGIFTCOUNT

This function retrieves a count of all the gifts a constituent has given.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_GETGIFTCOUNT(@CONSTITID uniqueidentifier)
            returns int
            as 
            begin
                declare @c int;
                select @c = count(ID)
                from REVENUE
                where CONSTITUENTID = @CONSTITID;

                return @c;
            end