Graber,

You are very close to what I need. But, row 16 should start with 1 and not row 15 becuase:

- the conter needs to start only when the...

Nikhil,

I already tried that and it is more complicated than I thought.

Jeff,

Thank you so much! That is perfect! 🙂

Jeff,

This solution is close to what I need, but I need to create groups. I cannot create groups with jbmRank. 🙁

PositionStartDateTime ...

Matt,

I tried that but that does not work because I need data that is out side the hour for example:

1 2005-08-14 05:48:00.000 ...

Geradin,

I do not have more data this is it. I do not have a grouping by. You are right, the time does not follow any patter. I...

Hi Garadin,

Well, I am very stressed out too.

What I really need to do is create groups or some kind of value that I can group by the position...

Joel Ewald,

Thank you very much! Yes, this is perfect! 🙂 I really appreciate your help!

12008-08-10 01:48:00.0003NULL

22008-08-10 01:54:00.0003NULL

32008-08-10 02:00:00.000131

42008-08-10 02:06:00.00032

52008-08-10 02:12:00.00033

62008-08-10 02:18:00.000154

72008-08-10 02:24:00.00035

82008-08-10 02:30:00.00036

92008-08-10 02:36:00.00037

102008-08-10 02:42:00.00038

112008-08-10 02:48:00.00039

122008-08-10 02:54:00.000310

132008-08-10 03:00:00.0003NULL

142008-08-10...

SSC Journeyman,

Thank you very much for the idea. However, this is not what I need.

Your suggestion produce this: ...

Lowell,

I really appreciate you idea but my output needs to be excatly like this:

I need to have the numbers from 1 to 10 per the condition.

StartDate value ...