UFN_PROSPECTSUMMARY

Returns the number of prospects for each fundraiser.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_PROSPECTSUMMARY()
            returns table
            as return
                select
                    PP.PRIMARYMANAGERFUNDRAISERID ID,
                    count(*) COUNT
                from
                    dbo.PROSPECTPLAN PP
                where
                    dbo.UFN_CONSTITUENT_ISFUNDRAISER(PP.PRIMARYMANAGERFUNDRAISERID) = 1 and
                    dbo.UFN_CONSTITUENT_ISPROSPECT(PP.PROSPECTID) = 1
                group by
                    PP.PRIMARYMANAGERFUNDRAISERID;