• I apologize that my statement confused the result I was looking for. How can I find the tables

    below that failed and were never successful for the same day? Some tables may succeed or fail

    more than once on the same day.

    /********* This is the table ***********/

    |TABLE_NAME | STATUS | START_TIME |

    Table1 fail 2014-11-22 02:05:00.000

    Table1 success2014-11-22 16:51:00.000

    Table2 success2014-11-22 05:59:00.000

    Table2 success2014-11-23 05:51:00.000

    Table3 fail 2014-11-22 05:30:00.000

    Table3 success 2014-11-23 06:50:00.000

    Table1 success2014-11-22 18:51:00.000

    /*********** End table ***************/

    Now how do I find out if those two entries Table1 and Table3 were later successful for 11/22/2014?