UFN_SELECTION_CONSTITUENT_CORRESPONDINGSPONSORS

Selection of all constituents that have an active sponsorship in their name.

Return

Return Type
table

Definition

Copy



CREATE function dbo.UFN_SELECTION_CONSTITUENT_CORRESPONDINGSPONSORS()
returns table
as return
    select distinct CONSTITUENTID ID
    from dbo.SPONSORSHIP
    where STATUSCODE = 1;