i'm new to SQL ecpeialy on DATE related operation
In my table starttime and endtime two columns are there, i need to find sum of total hours group by employeename.
how can i do this?
exm: EmpName Starttime EndTime
A 14/2/2012 25:20:00 14/2/2012 25:20:00
A 15/2/2012 20:20:00 15/2/2012 25:20:00
But i need output as
EmpName TotalHours
A 20:25:32(eg)
please help.............
Answers (3)
0
Can you let me know how you are populating data in the repeater in the code behind. If you are using a datatable it will be quite easy to build. Let me know.