UFN_DESIGNATION_REVENUECOUNTS

This function returns aggregate revenue information for designations.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_DESIGNATION_REVENUECOUNTS
            (@STARTDATE datetime, @ENDDATE datetime)
            returns @REVENUEINFO table
            (
                DESIGNATIONID uniqueidentifier NOT NULL PRIMARY KEY CLUSTERED,
                NUMDONORS int NOT NULL,
                NUMGIFTS int NOT NULL,
                MAXGIFT money NOT NULL
            )
            as
            begin
                insert @REVENUEINFO
                select
                    DESIGNATIONID,
                    NUMDONORS,
                    NUMGIFTS,
                    MAXGIFT
                from dbo.UFN_DESIGNATION_REVENUECOUNTS_2(@STARTDATE, @ENDDATE)

                return;
            end