fnGetConditionListsToUpdate

CREATE FUNCTION [dbo].[fnGetConditionListsToUpdate]
(
    @EmailJobID int
)
RETURNS
    @Lists TABLE
    (
        ID int
    )
AS
BEGIN
    declare @EMAILID int
    declare @CREATEDATE datetime
    select top 1 @EMAILID = EMAILID, @CREATEDATE = CreateDate from dbo.EMAILJOB where ID = @EMAILJOBID


    INSERT INTO @Lists
    SELECT DISTINCT(el.ID)
        FROM EmailJob ej
    JOIN EmailConditionBlock ecb
        ON   ej.EmailID = ecb.EmailID
    JOIN ConditionBlockCondition cbc
        on   cbc.ConditionBlockID = ecb.ConditionBlockID
    JOIN ConditionList cl
        on   cl.ConditionBlockConditionID = cbc.ID
    JOIN EmailList el
        on   el.ID = cl.EmailListID
    WHERE ej.ID = @EmailJobID
        AND   el.Origin = 2
        AND   ej.CreateDate > el.AcquiredDate
    RETURN
END