fnGetAvailableQueryRecords

create FUNCTION [dbo].[fnGetAvailableQueryRecords]
(
    @EmailListID INT,
    @AppealID INT,
    @AppealListID int
)
RETURNS @RES TABLE (BackofficeRecordID int)
as
begin

    declare @USEDPEOPLE table (PEOPLEID int)
    insert into @USEDPEOPLE
    SELECT elp.PeopleID
    FROM EmailList_People elp 
    INNER JOIN Email_Recipient er on elp.PeopleID = 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

    insert into @RES    
    SELECT bosp.BackofficeRecordID
    FROM fnGetTargetQueryAddresses(@EmailListID,@AppealID) fnta
    INNER Join BackOfficeSystemPeople bosp on fnta.[PeopleID] = bosp.[ID]
    left outer join @USEDPEOPLE u on u.PeopleID = fnta.[PeopleID]
    where u.PeopleID is null 

    return
end