USP_DATALIST_FUNDRAISER_PROSPECTSUMMARYBYROLE

Summary of prospects by fundraiser role for a given fundraiser.

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDRAISERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_FUNDRAISER_PROSPECTSUMMARYBYROLE(@FUNDRAISERID uniqueidentifier)
                as begin
                    set nocount on;
                    declare @CURRENTDATEEARLIESTTIME datetime;
                    set @CURRENTDATEEARLIESTTIME = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                    select
                        FUNDRAISERROLE,
                        count(*),
                        SEQUENCE
                    from 
                        dbo.UFN_FUNDRAISER_PROSPECTPLANS_3(@FUNDRAISERID,1,@CURRENTDATEEARLIESTTIME)
                    group by
                        FUNDRAISERROLE,
                        SEQUENCE
                    order by
                        SEQUENCE
                end