vpnsol123
asked on
Complex SQL script
I am in need of an SQL script that will calculate available time from a schedule base on a format and already used time. Here is an example. In my database when a schedule is formatted it is held as a string of zeros. Each zero represents 5 minutes, starting at midnight. So, if I schedule a 10 minute appointment as 8 AM, in order to be able to correctly track remaining available time in that schedule a 1 is placed in the 96th and 97th positions of the string of zeros. (2 slots of 5 minutes each = 10 minutes). I need to be able to run an sql script to look at the schedule and calculate the availability string base don what is already used.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.