ID CaseID CurrentDateTime FromName FromMessage
1 1 2012-07-31 16:42:16.000 admin@gmail.com TestMessage1
9 1 2012-08-02 09:56:58.000 Admin@gmail.com test no reply
10 1 2012-08-02 12:26:59.000 Admin@gmail.com hi
12 1 2012-08-04 11:05:51.000 Admin@gmail.com karthik
14 1 2012-08-06 09:49:05.000 Admin@gmail.com testMessage4
15 1 2012-08-06 09:59:04.000 Admin@gmail.com English
16 1 2012-08-07 09:41:49.000 Admin@gmail.com how are u
20 1 2012-08-07 11:31:26.000 Admin@gmail.com hello
21 1 2012-08-07 11:32:17.000 Mike@gmail.com hi I am Mike
33 1 2012-08-10 11:44:26.000 admin@gmail.com hi
37 1 2012-08-10 15:44:40.000 admin@gmail.com reply
38 1 2012-08-10 15:45:38.000 admin@gmail.com hi
39 1 2012-08-10 15:45:57.000 admin@gmail.com hi reply
54 1 2012-08-13 15:09:30.000 admin@gmail.com TestReply40
i have to Calulate the last Reply timing by stored Procedure where 1 --> 54 is CurrentDateTIme . I have many Case ID is like 2- 96 and goes ...
Go to the complete details ...