USP_GETINACTIVERECIPIENTDAYSLIMIT_BYEMAILID

Parameters

Parameter	Parameter Type	Mode	Description
@EMAILID	int	IN

Definition

Copy



create procedure dbo.USP_GETINACTIVERECIPIENTDAYSLIMIT_BYEMAILID
(
@EMAILID int
)
as
begin
    declare @inactiveRecipientFromMonths as int=0
    if exists (select Value from setting where id=148)
    begin
      select @inactiveRecipientFromMonths=Value from setting where id=148
    end
    else 
    begin
     set @inactiveRecipientFromMonths = 12
    end

    select IsExcludeInactiveRecipient,COALESCE(InactiveRecipientFromMonths, @inactiveRecipientFromMonths)  as InactiveRecipientFromMonths 
    from Email where id=@EMAILID 
end