USP_EMAIL_RECIPIENT_MERGERECIPIENTS

create procedure dbo.USP_EMAIL_RECIPIENT_MERGERECIPIENTS
(
  @EMAILID int
 )
as
begin
    merge dbo.EMAIL_RECIPIENT as T
    using
    (select ADDRESSBOOKID, USERID, DISPLAYNAME, EMAILADDRESS, BACKOFFICESYSTEMPEOPLEID, MERGEID, INVALIDADDRESS, OPTOUT, INVALIDACCOUNT, SOURCEID from #RECIPIENTS) as S
    on
    (T.emailid = @EMAILID and ((S.ADDRESSBOOKID > 0 and S.ADDRESSBOOKID = T.ADDRESSBOOKID) or (S.USERID > 0 and S.USERID = T.USERID)))
    when matched then
      update set ADDRESSBOOKID = S.ADDRESSBOOKID, 
        USERID = S.USERID, 
        DISPLAYNAME = S.DISPLAYNAME, 
        EMAILADDRESS = S.EMAILADDRESS, 
        BACKOFFICESYSTEMPEOPLEID = S.BACKOFFICESYSTEMPEOPLEID, 
        MERGEID = S.MERGEID, 
        INVALIDADDRESS = S.INVALIDADDRESS, 
        OPTOUT = S.OPTOUT, 
        INVALIDACCOUNT = S.INVALIDACCOUNT, 
        SOURCEID = S.SOURCEID
  when not matched then
    insert (EMAILID, ADDRESSBOOKID, USERID, DISPLAYNAME, EMAILADDRESS, BACKOFFICESYSTEMPEOPLEID, MERGEID, INVALIDADDRESS, OPTOUT, INVALIDACCOUNT, SOURCEID)
    values (@EMAILID, S.ADDRESSBOOKID, S.USERID, S.DISPLAYNAME, S.EMAILADDRESS, S.BACKOFFICESYSTEMPEOPLEID, S.MERGEID, S.INVALIDADDRESS, S.OPTOUT, S.INVALIDACCOUNT, S.SOURCEID);

end