After looking at Drew.Allen's solution, I realize that it works just as well for multiple cars over multiple days, so that is what I was looking for. We are trying...

Drew, thank you for your reply. Your method seems more like what I was looking for. I modified it just a little by adding your final select as a last...

Here's a revised test data load script (with more cars), still using the 'Select/Union all' but should be working:

-- Remove the table if it already exists
IF OBJECT_ID('TempDB..#testStationSum',...

• This reply was modified 1 year, 5 months ago by  jwilkerson@valleymetro.org.

Thank you for replying Jonathan, and I see your point about the ordering. I am still trying to discover what might work so I had left some things in the...

Thanks for the suggestions. Sorry about not making it easier to work with the data, here is the data setup info:

-- Remove the table if it already...