USP_EMAIL_RECIPIENT_ADDRECIPIENTS

CREATE procedure dbo.USP_EMAIL_RECIPIENT_ADDRECIPIENTS
as
begin
    insert into dbo.Email_Recipient(EMAILID, ADDRESSBOOKID, USERID, DISPLAYNAME, EMAILADDRESS, BACKOFFICESYSTEMPEOPLEID, MERGEID, INVALIDADDRESS, OPTOUT, INVALIDACCOUNT, SOURCEID,INACTIVE)
  select EMAILID, ADDRESSBOOKID, USERID, DISPLAYNAME, EMAILADDRESS, BACKOFFICESYSTEMPEOPLEID, MERGEID, INVALIDADDRESS, OPTOUT, INVALIDACCOUNT, SOURCEID, INACTIVE from #RECIPIENTS order by EMAILID;
end