Link to home
Start Free TrialLog in
Avatar of vpnsol123
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
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial