USP_SEARCHLIST_EMAIL_INVALIDACCOUNT

Search invalid email accounts.

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESS	nvarchar(255)	IN	Email address
@DATEAFTER	datetime	IN	Processed after
@DATEBEFORE	datetime	IN	Processed before
@ISBLACKLISTED	bit	IN	Is blacklisted
@FAILEDMESSAGE	nvarchar(1000)	IN	Bounce message
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_EMAIL_INVALIDACCOUNT
(
    @ADDRESS nvarchar(255) = null,
    @DATEAFTER datetime = null,
    @DATEBEFORE datetime = null,
    @ISBLACKLISTED bit,
    @FAILEDMESSAGE nvarchar(1000),
    @MAXROWS smallint = 500
)
as
    set @ADDRESS = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@ADDRESS, 0, null);
    set @FAILEDMESSAGE = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@FAILEDMESSAGE, 0, null);
    set @DATEAFTER = COALESCE(@DATEAFTER,cast('1980-01-01' as datetime));
    set @DATEBEFORE = COALESCE(@DATEBEFORE,cast('3000-01-01' as datetime));

    select top(@MAXROWS)
        ID,
        ADDRESS,
        ISBLACKLISTED,
        FAILEDATTEMPTS,
        DATEPROCESSED,
        FAILEDMESSAGE
    from 
        dbo.EMAILINVALIDRECIPIENT
    where
        (ISBLACKLISTED = @ISBLACKLISTED) and
        ((@ADDRESS is null) or (ADDRESS like @ADDRESS)) and
        ((@FAILEDMESSAGE is null) or (FAILEDMESSAGE like @FAILEDMESSAGE)) and
        (DATEPROCESSED >= @DATEAFTER) and
        (DATEPROCESSED <= @DATEBEFORE)
    order by 
        DATEPROCESSED desc