USP_EMAILJOB_RECIPIENT_ADDEMAILRECIPIENTS

CREATE procedure dbo.USP_EMAILJOB_RECIPIENT_ADDEMAILRECIPIENTS
(
  @EMAILJOBID int,
  @EMAILID int
)
as
begin

declare @Date datetime = GETUTCDATE();

insert into dbo.EMAILJOB_RECIPIENT(EMAILID, EMAILJOBID, UPDATEDATE, ADDRESSBOOKID, EMAILRECIPIENTID, USERID, EMAILADDRESS, BACKOFFICESYSTEMPEOPLEID, MERGEID, SOURCEID)
select @EMAILID, @EMAILJOBID, @DATE, 0, ER.ID, ISNULL(ER.USERID,0), ER.EMAILADDRESS, ER.BACKOFFICESYSTEMPEOPLEID, ER.MERGEID, ER.SOURCEID
from dbo.EMAIL_RECIPIENT ER with (nolock)
where ER.EMAILID = @EMAILID and ER.OPTOUT = 0 and ER.INVALIDADDRESS = 0 and ER.INVALIDACCOUNT = 0 and isnull(ER.INACTIVE,0) = 0;

end