USP_COMMUNICATION_GETEMAILJOBSTATUSIDS
Retrieves the email status ids associated with all communication letters for the given communication.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_COMMUNICATION_GETEMAILJOBSTATUSIDS
(
@SEGMENTATIONID uniqueidentifier
)
as begin
select
COMMUNICATIONLETTER.EMAILSTATUSID
from dbo.COMMUNICATIONLETTER
where COMMUNICATIONLETTER.SEGMENTATIONID = @SEGMENTATIONID
and COMMUNICATIONLETTER.EMAILSTATUSID is not null
end