deference between two columns in two Sequenced rows

[Ahmed El Badry]

table name trips starttime endtime triptime Stoprate 14/08/2008 10:39:00 PM 14/08/2008 10:56:00 PM 16 3 14/08/2008 10:59:00 PM 14/08/2008 11:1:00 PM 2 i want the sql queries to create stoprte value

Ahmed El-Badry

[Wendelius]

Ahmed El-Badry wrote:

i want the sql queries to create stoprte value

Could you be more specific what you're trying to achieve? You want to calculate stoprate value with what kind of formula?

The need to optimize rises from a bad design.My articles[^]

[Ahmed El Badry]

i want calculate stoprate value table name trips starttime endtime triptime Stoprate 14/08/2008 10:39:00 PM 14/08/2008 10:56:00 PM 16 3 14/08/2008 10:59:00 PM 14/08/2008 11:1:00 PM 2 stop value = 14/08/2008 10:56:00 PM - 14/08/2008 10:59:00 PM = 3 i want the sql queries to calculate stoprte value

Ahmed El-Badry

[Wendelius]

So the stoprate is endtime from row 1 - starttime from row 2 in minutes? If that's correct, you could use something like:

select datediff(minute,
trips.endtime,
(select min(t2.starttime)
from trips t2
where t2.starttime > trips.endtime))
from trips...

The need to optimize rises from a bad design.My articles[^]

[Ahmed El Badry]

thnx i will tray it :)

Ahmed El-Badry

[Wendelius]

You're welcome. :)

The need to optimize rises from a bad design.My articles[^]