UFN_SELECTION_CONSTITUENT_INACTIVE

Returns all CONSTITUENT IDs for inactive constituents.

Return

Return Type
table

Definition

Copy



        create function dbo.UFN_SELECTION_CONSTITUENT_INACTIVE()
        returns table
        as return
        SELECT ID from dbo.CONSTITUENT WITH (NOLOCK) WHERE ISINACTIVE=1;