USP_KPI_BBNC_EMILDONATEDCOUNT

Parameters

Parameter	Parameter Type	Mode
@VALUE	int	INOUT
@ASOFDATE	datetime	IN
@DATEFILTER	tinyint	IN
Definition

Copy


                    CREATE procedure dbo.USP_KPI_BBNC_EMILDONATEDCOUNT
                        @VALUE int output,
                        @ASOFDATE datetime, 
                        @DATEFILTER tinyint = null
                    as

                        set nocount on;

                        if @DATEFILTER is null begin
                            set @DATEFILTER = 10;  -- all dates;

                        end

                        declare @STARTDATE datetime;
                        declare @ENDDATE datetime;

                        exec dbo.USP_RESOLVEDATEFILTER @DATEFILTER=@DATEFILTER, @STARTDATE=@STARTDATE output, @ENDDATE=@ENDDATE output, @ASOFDATE=@ASOFDATE;

                        select 
                            @VALUE = count(*)  
                        from 
                            dbo.NETCOMMUNITYEMAILJOBRECIPIENT
                        where
                            SENTDATE between @STARTDATE and @ENDDATE
                            and UPDATEDATE is not null --Newsletter subscriptions can generate incomplete email job recipient rows

                            and DONATED = 1;

                        if @VALUE is null begin
                            set @VALUE = 0;
                        end