Calculating consecutive Date/Time records

[turtle]

I have a query that returns the results of a process. The start time
for Step 2 is the End Time for step 1. I need to know how long each
step takes.

My current query

Product Step
24324201-05 Step1 7/31/2007 12:11:53 AM
24324201-05 Step2 7/31/2007 12:12:00 AM
24324201-05 Step3 7/31/2007 12:12:21 AM

[turtle]

On Aug 13, 3:32 pm, turtle <[e-mail]:

I have a query that returns the results of a process. The start time
for Step 2 is the End Time for step 1. I need to know how long each
step takes.

My current query

Product Step
24324201-05 Step1 7/31/2007 12:11:53 AM
24324201-05 Step2 7/31/2007 12:12:00 AM
24324201-05 Step3 7/31/2007 12:12:21 AM

What i want to do is calculate the difference from step 1 to step 2 on
the first record and then the dif between step 2 and step 3 on the 2nd
record.
thanks
KO

[John Winterbottom]

select A.product, 'Step' & count(*) as StepNbr, A.step
from
(
select product, step
from products
) as A
inner join
(
select product, step
from products
) as B
on A.product = B.product
and A.Step >= B.Step
group by A.product, A.step

turtle wrote:

I have a query that returns the results of a process. The start time
for Step 2 is the End Time for step 1. I need to know how long each
step takes.

My current query

Product Step
24324201-05 Step1 7/31/2007 12:11:53 AM
24324201-05 Step2 7/31/2007 12:12:00 AM
24324201-05 Step3 7/31/2007 12:12:21 AM

[John Winterbottom]

or:

select A.product, 'Step' & count(*) as StepNbr, A.step
from products as A
inner join products as B
on A.product = B.product
and A.Step >= B.Step
group by A.product, A.step

John Winterbottom wrote:

select A.product, 'Step' & count(*) as StepNbr, A.step
from
(
select product, step
from products
) as A
inner join
(
select product, step
from products
) as B
on A.product = B.product
and A.Step >= B.Step
group by A.product, A.step