I have data in the form of
DateTime -- Status -- Duration Seconds 12:00:00, Available, 10800 15:00:00, Unavailable, 460
I need to translate that into
DateTime -- Status 12:00:00, Available 13:00:00, Available 14:00:00, Available 15:00:00, Unavailable
The logic to extrapolate the data this way is simple, but translating it into SQL is proving to be difficult. Any assistance would be greaty appreciated!