USP_NETCOMMUNITYEMAILJOBRECIPIENT_EMAILDELETE

create procedure dbo.USP_NETCOMMUNITYEMAILJOBRECIPIENT_EMAILDELETE
(
@EMAILID int
)
as
begin
  set nocount on;

  merge into NETCOMMUNITYEMAILJOBRECIPIENT ncejr
    using Email em
      on em.ID = ncejr.EMAILBBNCMAPID
        and em.ID = @EMAILID
  when matched then
    update
      set ncejr.APPEALID = em.AppealID,
      ncejr.EMAILTYPEID = em.[Type],
      ncejr.EMAILDELETED = 1,
      ncejr.URL = '';

end