UFN_SELECTION_CONSTITUENT_PROSPECTS

Gets all constituents who have ever been major giving prospects, regardless of current major giving prospects status.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_SELECTION_CONSTITUENT_PROSPECTS()
            returns table
            as return
                select distinct
                    PROSPECTDATERANGE.[CONSTITUENTID] as [ID]
                from
                    dbo.PROSPECTDATERANGE;