fnGetAvailableXListRecords
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailListID | int | IN | |
| @AppealID | int | IN | |
| @AppealListID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnGetAvailableXListRecords]
(
@EmailListID INT,
@AppealID INT,
@AppealListID int
)
RETURNS TABLE as RETURN
SELECT fnta.[ID]
FROM fnGetTargetXListAddresses(@EmailListID, @AppealID) fnta
left outer join
(
SELECT bosp.[BackOfficeRecordID]
FROM EmailListUploadMasterList ml
INNER JOIN BackOfficeSystemPeople bosp on ml.BB_XListRecordID = bosp.BackOfficeRecordID
INNER JOIN Email_Recipient er on bosp.[ID] = er.BackOfficeSystemPeopleID
INNER JOIN Email e on er.EmailID = e.[ID]
INNER JOIN EmailProjectAppeal_ListEmail epale on e.[ProjectAppealListEmailID] = epale.[ID]
WHERE epale.[EmailProjectAppealListID] = @AppealListID
) usedPeople on usedPeople.[BackOfficeRecordID] = fnta.[ID]
where usedPeople.[BackOfficeRecordID] is null