How to sum time of two rows in sql server
1 Med1 2013-09-10 ec2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 61 01:28:27.0000000
2 Med1 2013-09-10 ec2700 Karthiga G Miscellaneous Other
Periodical or special adjustments 2013-05-21 W6 108 02:36:36.0000000
3 Med1 2013-09-10 ec2700 Karthiga G Miscellaneous # of rows
updated in Audit Log 2013-05-21 W6 61 00:20:20.0000000
4 Med1 2013-09-10 ec2700 Karthiga G Miscellaneous # of Errors
identified/updated in Audit Log 2013-05-21 W6 4 00:08:08.0000000
40 Med1 2013-09-11 ec2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 37 00:53:39.0000000
41 Med1 2013-09-11 ec2700 Karthiga G Miscellaneous Other
Periodical or special adjustments 2013-05-21 W6 244 05:53:48.0000000
42 Med1 2013-09-11 ec2700 Karthiga G Miscellaneous # of rows
updated in Audit Log 2013-05-21 W6 37 00:12:20.0000000
43 Med1 2013-09-11 ec2700 Karthiga G Miscellaneous # of Errors
identified/updated in Audit Log 2013-05-21 W6 1 00:02:02.0000000
184 Med1 2013-09-12 EC2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 27 00:39:09.0000000
185 Med1 2013-09-12 EC2700 Karthiga G Miscellaneous Other
Periodical or special adjustments 2013-05-21 W6 264 06:22:48.0000000
186 Med1 2013-09-12 EC2700 Karthiga G Miscellaneous # of rows
updated in Audit Log 2013-05-21 W6 27 00:09:00.0000000
343 Med1 2013-09-13 ec2700 Karthiga G Charges NTP - Import Charge
Entry 2013-05-21 W6 30 01:16:30.0000000
344 Med1 2013-09-13 ec2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 49 01:11:03.0000000
345 Med1 2013-09-13 ec2700 Karthiga G Miscellaneous # of rows
updated in Audit Log 2013-05-21 W6 49 00:16:20.0000000
354 Med1 2013-09-13 ec2700 Karthiga G Miscellaneous Other
Periodical or special adjustments 2013-05-21 W6 57 01:22:39.0000000
508 Med1 2013-09-14 ec2700 Karthiga G Charges NTP - Import Charge
Entry 2013-05-21 W6 100 04:15:00.0000000
510 Med1 2013-09-14 ec2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 53 01:16:51.0000000
511 Med1 2013-09-14 ec2700 Karthiga G Miscellaneous # of rows
updated in Audit Log 2013-05-21 W6 53 00:17:40.0000000
604 Med1 2013-09-16 ec2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 39 00:56:33.0000000
605 Med1 2013-09-16 ec2700 Karthiga G Charges NTP - Import Charge
Entry 2013-05-21 W6 96 04:04:48.0000000
606 Med1 2013-09-16 ec2700 Karthiga G Payments NTP - Payment
Entry 2013-05-21 W6 14 00:25:54.0000000
607 Med1 2013-09-16 ec2700 Karthiga G Miscellaneous Un-assigned /
Copay Payment Posting 2013-05-21 W6 134 01:24:52.0000000
738 Med1 2013-09-17 EC2700 Karthiga G Charges NTP - Import Charge
Entry 2013-05-21 W6 102 04:20:06.0000000
739 Med1 2013-09-17 EC2700 Karthiga G Payments NTP - Payment
Entry 2013-05-21 W6 32 00:59:12.0000000
740 Med1 2013-09-17 EC2700 Karthiga G Audits Centricity - Charge
Audit 2013-05-21 W6 40 00:58:00.0000000
741 Med1 2013-09-17 EC2700 Karthiga G Miscellaneous Un-assigned /
Copay Payment Posting 2013-05-21 W6 136 01:26:08.0000000
742 Med1 2013-09-17 EC2700 Karthiga G Miscellaneous # of rows
updated in Audit Log 2013-05-21 W6 40 00:13:20.0000000
933 Med1 2013-09-18 ec2700 Karthiga G Charges NTP - Import Charge
Entry 2013-05-21 W6 105 04:27:45.0000000
934 Med1 2013-09-18 ec2700 Karthiga G Payments NTP - Payment
Entry 2013-05-21 W6 48 01:28:48.0000000
935 Med1 2013-09-18 ec2700 Karthiga G Miscellaneous Other
Periodical or special adjustments 2012-01-01 W6 88 02:07:36.0000000
No comments:
Post a Comment