Viewing 5 posts - 1 through 5 (of 5 total)
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...
June 5, 2023 at 4:33 pm
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...
June 5, 2023 at 4:10 pm
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',...
June 5, 2023 at 3:57 pm
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...
June 5, 2023 at 3:45 pm
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...
June 2, 2023 at 5:09 pm
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy