sql function
-
I have created sql function and stored procedure to calculate work hours of an employee. timein,timeout,workingHours are the fields. eg: TimeIn TimeOut WorkingHours 9:20:00 AM 11:59:59 PM 14:39:59 00:01:00 AM 3:56:40 AM 3:55:40 I calculated workHours using datediff.I have to calculate the sum of WorkingHours also.What can I do for this??Really I m confused..:confused:
-
I have created sql function and stored procedure to calculate work hours of an employee. timein,timeout,workingHours are the fields. eg: TimeIn TimeOut WorkingHours 9:20:00 AM 11:59:59 PM 14:39:59 00:01:00 AM 3:56:40 AM 3:55:40 I calculated workHours using datediff.I have to calculate the sum of WorkingHours also.What can I do for this??Really I m confused..:confused:
Did you try SUM function to get sum of working hours. example: select sum(workinghours) from mytable Or post your query and we will see how concretely to add too sum of working hours.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com