|
Now that you all helped on the query as in below. How can I get the total time hh:mm:ss and get the average of it?
(comments are locked)
|
|
This is an example of using aggregate function on sets of data that you can hopefully use to apply the same logic to your dataset here is an example that works with time data you will need to consider whether to use seconds (as I have) or whether minutes or hours or even milliseconds are more useful for you.
(comments are locked)
|
|
taking your previous sample data, this is the way you'd get the average, and the sum is gotten simply by changing AVG to SUM It will need to be min:Sec
Apr 30 '12 at 03:14 PM
jaymz69
in what sense is my solution not in that format? OK, it will be in hh:mm:ss but you might need that.
Apr 30 '12 at 03:35 PM
Phil Factor
(comments are locked)
|


Welcome to the site. I edited this with the code tag to make it easier to read.
Thank you
I get this message error. I know follow the error and debug it, but FYI...
Msg 8115, Level 16, State 5, Line 3 Arithmetic overflow error converting numeric to data type varchar.