UFN_SELECTION_CONSTITUENT_NONDONORS

        CREATE function dbo.UFN_SELECTION_CONSTITUENT_NONDONORS()
        returns table

        --Returns all CONSTITUENT IDs that have never given a gift, regardless of Active status.


        as return

        SELECT ID 
        from dbo.CONSTITUENT WITH (NOLOCK)
        WHERE
        ID NOT IN (
                    SELECT CONSTITUENTID AS ID from dbo.REVENUE WITH (NOLOCK)
                  );