UFN_CONSTITUENT_GETREQUESTNOEMAIL

                CREATE FUNCTION [dbo].[UFN_CONSTITUENT_GETREQUESTNOEMAIL]
        (
        @ID int
        )
        RETURNS bit
        AS
        BEGIN
        declare @NOEMAILSOLICITCODEID uniqueidentifier
        select top 1 @NOEMAILSOLICITCODEID=DONOTEMAILSOLICITCODEID
        from dbo.NETCOMMUNITYDEFAULTCODEMAP

        declare @CONSTITUENTSOLICITCODEID uniqueidentifier
        select @CONSTITUENTSOLICITCODEID=csc.ID
        from dbo.CONSTITUENTSOLICITCODE csc
        join dbo.CONSTITUENT c on c.ID=csc.CONSTITUENTID
        where c.SEQUENCEID=@ID and
        csc.SOLICITCODEID=@NOEMAILSOLICITCODEID and
        ((csc.STARTDATE is null) or (datediff(day, csc.STARTDATE, getdate())>=0)) and
        ((csc.ENDDATE is null) or (datediff(day, getdate(), csc.ENDDATE)>=0))

        declare @REQUESTNOEMAIL bit
        if @CONSTITUENTSOLICITCODEID is null
        set @REQUESTNOEMAIL = 0
        else
        set @REQUESTNOEMAIL = 1

        return @REQUESTNOEMAIL

        END