USP_EMAIL_RECIPIENT_UPDATERECIPIENTS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILID | int | IN |
Definition
Copy
create procedure dbo.USP_EMAIL_RECIPIENT_UPDATERECIPIENTS
(
@EMAILID int
)
as
begin
update dbo.Email_Recipient set MERGEID=newid() where EmailID=@EMAILID AND SOURCEID is NULL;
end