fnGetTargetXListAddresses

CREATE FUNCTION [dbo].[fnGetTargetXListAddresses]
(
    @EmailListID INT,
    @AppealID int
)
RETURNs TABLE AS RETURN

SELECT ml.BB_XListRecordID "ID" 
FROM EmailListUploadMasterList ml 
left outer join fnGetExclusionEmailAddresses(@AppealID) fnxea on fnxea.EmailAddress = ml.EmailAddress
WHERE ml.EmailListID = @EmailListID AND IsNull(ml.EmailAddress, '') <> '' 
AND fnxea.EmailAddress is null