spHandleInvalidAccount

CREATE PROCEDURE spHandleInvalidAccount(@EmailAddress nvarchar(255), @EmailJobRecipientID int, @ProcessDate datetime)
AS
BEGIN
    set nocount on
    declare @ID int
    select @ID = isnull(ID, 0)
    from EmailInvalidAccount
    where emailaddress = @EmailAddress    

    if @ID > 0
        begin
        update EmailInvalidAccount
        set [Count] = [Count] + 1,
        Active = 1,
        UpdateDate = @ProcessDate
        where EmailAddress = @EmailAddress
        end
    else
        begin
            insert into EmailInvalidAccount (EmailAddress, [Count], Active, CreateDate, UpdateDate)
            values(@EmailAddress, 1, 1, @ProcessDate, @ProcessDate)
            set @ID = @@Identity
        end
    INSERT INTO EmailInvalidAccountRecipient(EmailInvalidAccountID, EmailJobRecipientID, CreateDate, UpdateDate)
    VALUES(@ID, @EmailJobRecipientID, @ProcessDate, @ProcessDate)    
END