UFN_CONSTITUENT_ISSPONSOR

Validates whether the constituent record is a sponsor.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



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

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

                return 0;
            end