UFN_CONSTITUENT_ISCOMMITTEE

This functions returns whether a constituent is a committee as of the given date.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_CONSTITUENT_ISCOMMITTEE(@CONSTITUENTID uniqueidentifier)
        returns bit
        with execute as caller
        as begin
            declare @CURRENTDATEEARLIESTTIME date;
            set @CURRENTDATEEARLIESTTIME = getdate();

            if exists(
                select
                    ID
                from
                    dbo.COMMITTEEDATERANGE
                where
                    COMMITTEEDATERANGE.CONSTITUENTID = @CONSTITUENTID and
                    (COMMITTEEDATERANGE.DATEFROM <= @CURRENTDATEEARLIESTTIME or COMMITTEEDATERANGE.DATEFROM is null) and
                    (COMMITTEEDATERANGE.DATETO >= @CURRENTDATEEARLIESTTIME or COMMITTEEDATERANGE.DATETO is null)
            ) return 1;

            return 0;
        end