Did that. 
It just deleted both schedules at some point and created an entirely new hourly schedule (with a new ID).

This is just the oddest behavior.

The GUI doesn't allow me to modify hourly settings beyond just sending a report every hour.  I've done this to reports/jobs before and have never had any issues ...until this...

Thank you for all the info, Steve.  I'll be checking out how we'll be approaching this moving forward.

Much appreciated.

Wow, thanks Steve.  Very detailed explanation there. 

I would say the data has a pattern week over week with each day of week typically having a trend compared...

Thank you, Steve.  How much of a dataset would be best to have for something like this? Also, would it be better if I looked at this on a day by day...

It seems I may have just needed to join on a few more key columns and that vastly improved my performance.

Apologies for the newbie move, and thank you for...

....I think I figured it out.

I recently had copied over the original project to a new computer, (and apparently didn't test the original reports before importing the new...

I think I figured it out. 

I was using the equality comparison (IN) against the wrong field.  I changed the code to this:

SELECT DISTINCT...

Thank you, Drew!

That did get me in the right direction (I think).  At the very least I now have a cool string splitter function.  I got something working...

My apologies, Lynn.  Thank you for your input here.

The problem got a little more complex with additional columns added for each address.  So now, instead of just getting...

How would the CASE statement look?  Would it be a case for each column, something like this?:

SELECT CASE WHEN pickup_address < dropoff_address THEN...

Drew.allen - I think that might be it!

I dumped the CASE data into a temp table and added a SELECT DISTINCT ADDRESS1, ADDRESS2 to get the distinct list...

Thanks for the info. Maybe this will clarify:

My ultimate goal is to only find the distinct combination of two addresses in this table.  (Regardless of the passenger or TripID...

Thanks everyone.  I didn't know the name of the operator, but ended up figuring out that it did something with the remainder as well.  Good to know the actual name!