UFN_CONSTITUENT_ANONYMOUSDONORS

This function returns all constituents who have given an anonymous donation.

Return

Return Type
table

Definition

Copy



create function dbo.UFN_CONSTITUENT_ANONYMOUSDONORS()
returns table
as 
    return (
        select
            distinct CONSTITUENTID as ID
        from dbo.REVENUE
        where GIVENANONYMOUSLY = 1
    )