UFN_STEPSUMMARY_COMPLETED

create function dbo.UFN_STEPSUMMARY_COMPLETED
(
    @STARTDATE datetime, 
    @INCLUDESTEWARDSHIP bit
)
returns @data table(
    ID uniqueidentifier,
    COUNT integer    
)
as begin
    insert into @data
        select 
            I.FUNDRAISERID ID, 
            count(*) COUNT
        from 
            dbo.INTERACTION I
        where 
            I.COMPLETED=1
            and I.DATE > @STARTDATE
        group by
            I.FUNDRAISERID

    if @INCLUDESTEWARDSHIP = 1
        merge @data as data
        using (
            select
                STEP.CONSTITUENTID ID,
                count(*) COUNT
            from
                dbo.STEWARDSHIPPLANSTEP STEP                
            where
                not STEP.CONSTITUENTID is null
                and STEP.STATUSCODE = 1
                and STEP.ACTUALDATE >= @STARTDATE
            group by STEP.CONSTITUENTID
        ) steps
            on data.ID = steps.ID
        when matched then update set data.COUNT = data.COUNT + steps.COUNT
        when not matched by target then insert values(steps.ID, steps.COUNT);

    return;
end