David, elegant or not, I'm impressed!

I'm going through trying to deconstruct it so I understand how it works, but in validating the data this looks spot on for what I...

Thanks Dixie, but this just groups each passenger into a group.  Not quite what I was looking for.  If you look at the last set of test data with the...

I'm all for seeing how someone would do this start to end, I just wasn't sure if I was asking too much.  And I wasn't sure if my original inquiry...

Thank you for your help, but I'm not sure how this helps.  I already know when passengers board and disembark in the PassOB and PassOB_Bit columns (plus I have another...

Apologies.  My mind is a little scattered, apparently.

Fresh data with query:

CREATE TABLE #test
(RN INT
,LDATE INT
,EVSTRNAME VARCHAR(20)
,BOOKINGID INT
,ACTUALARRIVETIME INT
,ACTUALDEPARTTIME INT
,EVORDER INT
,ODOMETER INT
,PASSOB VARCHAR(50)
,PASSOB_BIT INT
,CLUSTER INT
)

INSERT #test ([rn], [ldate],...

I think we're getting off-track here.

Without going into too much detail, this is the business process and the goal here is to see how we can identify specific trips to...

Productivity is defined on a route level (and rolled up to all hours for the day) divided by trips completed.  So if we did 1500 trips in a total of...

Hello all,

Thank you for your input here.  It's interesting to see how the question is being interpreted; I'm seeing a few assumptions being made but I'm not sure if that's...

*Palm to face.

Sorry I missed that one.

I'm just having a really difficult time trying to use the code originally provided, and tweaking it with the links also provided (both extremely...

Thank you, Drew.  That's a very well written article.  I didn't even know the term for this was Packing Intervals, so learn something new every day.

Of course, I tried using...

Hello again,

In running through the code for this which Mark provided above (thank you, Mark!), I've discovered that the Min/Max minute calculations between idle periods sometimes excludes records because they're...

Mark, you are the man.

I found a snippet from another query referencing lat/lon comparisons and made a slight adjustment:

Instead of AND (SQUARE(t2.LAT-t1.LAT) + SQUARE(t2.LON-t1.LON)) > SQUARE(500)

I used AND (ABS(t2.Lon-t1.Lon) >...

Never mind! I fat fingered it.

I got it to run, now I'll see what I have...

Thank you so  much! Glad I now have something to start with.  Very much appreciated!

Thanks Mark!

I tried to run this but I'm getting an error "an expression of non-Boolean type specified in a context where a condition is expected, near ';' " right at...

The job isn't getting modified by anyone (other than when we try to make the changes we need).  The regular hourly schedule works fine for regular hourly functionality, (including making...