UFN_SELECTION_CONSTITUENT_LARGEDONORS

Returns all CONSTITUENT IDs for constituents who have given $5000+ gifts.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_SELECTION_CONSTITUENT_LARGEDONORS
            (
            )
            returns table
            as return 
            select 
                distinct CONSTITUENTID as [ID]
            from dbo.REVENUE 
            group by REVENUE.ID, CONSTITUENTID
            having sum(AMOUNT) >= 5000