OK, I'll try and explain this 'logically':
My MS SQL application records outputs from a production line in real time. If I want to sum an output from a particular production line for a time period (say a month) and group by day, that works fine. The problem is that our 'Days' run from 7am to...