Please review the attached example dataset.
I need to be able to convert the sheet of store hours of operation to individual rows that represent one row per 15 minute interval.
Example from Worksheet Store 1001 is open from 00:00 to 00:00 which is 24 hours a day or 96 1/4 hour intervals.
So I would need SQL to return a dataset that basically states that Store 1001 Saturday 00:00 00:15 the next row would be Store 1001 Saturday 00:015 to 00:30 for all 96 intervals of the day on every day of the week.
Example 2 from Worksheet Store 1002 is open from 07:00 until 23:00
I would need SQL to return a dataset that basically states that Store 1002 Saturday 07:00 07:15 the next row would be Store 1001 Saturday 07:015 to 07:30 for all 64 intervals of the day on every day of the week.
Is there a method that would allow me to leverage SQL with the data I have available in the worksheet which comes from a table on SQL Server to return every 15 minute interval that a store is open?
Thank you in advance experts for any assistance you can provide.