UFN_STEPSUMMARY_PLANNED

Returns the number of planned steps for a fundraiser up until a given date.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ENDDATE	datetime	IN

Definition

Copy



            create function dbo.UFN_STEPSUMMARY_PLANNED(@ENDDATE datetime)
            returns table
            as return (
                select
                    I.FUNDRAISERID ID, 
                    count(*) COUNT
                from 
                    dbo.INTERACTION I
                where 
                    I.COMPLETED=0
                    and I.DATE<@ENDDATE
                group by 
                    I.FUNDRAISERID
            )