spLoadRecord_LoadIncompleteEventTransactions

    CREATE PROCEDURE dbo.[spLoadRecord_LoadIncompleteEventTransactions]
    @BEGINDATE datetime,
    @ENDDATE datetime
    AS
    BEGIN
    SELECT EventTransactionsID,DateAdded,TransactionGUID
    FROM dbo.[EventTransactions]
    WHERE
    Status = 0 AND
    IsDeleted = 0 AND
    FailureData IS NULL AND
    processed_date IS NULL AND
    DateAdded BETWEEN @BEGINDATE AND @ENDDATE
    END