# question

## how to calualate based on vspeed zero means Logdatetime Day,hrs,min,second (d:h:m:s)

how to calualate based on vspeed zero means Logdatetime Day,hrs,min,second (d:h:m:s) table1 VehicleSpeed LogDateTime 15.000000 2015-05-28 11:36:17.000 0.000000 2015-05-28 11:36:17.000 0.000000 2015-05-28 12:01:08.000 0.000000 2015-05-28 04:00:12.000 0.000000 2015-05-28 05:58:05.000 20.000000 2015-05-29 11:13:03.000 25.000000 2015-05-29 13:48:12.000 0.000000 2015-05-29 16:51:03.000 0.000000 2015-05-29 17:04:07.000 0.000000 2015-05-30 11:37:35.000 50.000000 2015-05-30 11:37:38.000 40.000000 2015-05-30 11:37:38.000 0.000000 2015-06-11 02:13:08.000 0.000000 2015-06-11 02:19:42.000 plz help me any one

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

·
Your post is formatted so poorly we can't begin to decipher it. In general to calculate speed you need to have two things, time and distance. We can calculate the time as the difference between entries but we also would need to know the distance. You might want to take a look at this article. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
2 Likes 2 ·
·
@priyamca3 this is the 6th question you have posted in the past 3 weeks, all with the same general idea behind them. None of your previous questions seem to have had useful answers, but there have been many requests for clarification. We cannot help you to arrive at the answers you need if you cannot present the problem and desired results more clearly. In the question, we have what looks like a series of data points that indicate the speed at which a vehicle was traveling and the time at which the speed was recorded. Using just those two columns as our starting point, what is the calculated value you want to see? Are you hoping to add a 3rd column to the sample data? Arrive at an aggregated result with a single row? Incorporate data from another table that hasn't been mentioned? Something else?
2 Likes 2 ·
·
I don't understand what you're trying to calculate.
0 Likes 0 ·
·
Now it is formatted but there just aren't enough details to offer any help here. What are you trying to calculate? What would be the expected output from the sample data?
0 Likes 0 ·