UFN_SELECTION_CONSTITUENT_BOARDMEMBERS_CURRENT

Returns all CONSTITUENT IDs for constituents have a row in the BOARDMEMBER table where the current date is within DATETO DATEFROM range.

Return

Return Type
table

Definition

Copy



        CREATE function dbo.UFN_SELECTION_CONSTITUENT_BOARDMEMBERS_CURRENT()
        returns table
        as return

        select DISTINCT CONSTITUENTID as [ID] from dbo.BOARDMEMBERDATERANGE
        WHERE 
        GETDATE() BETWEEN

        COALESCE(DATEFROM,'1900-01-01') 
        AND 
        COALESCE(DATETO,'3100-01-01') ;