UFN_SELECTION_CONSTITUENT_STAFF

Gets all constituents who have ever been staff, regardless of current staff status.

Return

Return Type
table

Definition

Copy



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