fnGetTargetQueryAddresses
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailListID | int | IN | |
| @AppealID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnGetTargetQueryAddresses]
(
@EmailListID INT,
@AppealID int
)
RETURNs TABLE AS RETURN
SELECT elp.[ID], elp.[PeopleID]
FROM EmailList_People elp
left outer join dbo.fnGetExclusionEmailAddresses(@AppealID) fnxea on fnxea.EmailAddress = elp.EmailAddress
WHERE elp.EmailListID = @EmailListID AND IsNull(elp.EmailAddress, '') <> ''
and fnxea.EmailAddress is null