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?