Calculate open timeslots given availability and existing appointments - by day

Posted by Andre on Stack Overflow See other posts from Stack Overflow or by Andre
Published on 2010-12-23T17:20:56Z Indexed on 2010/12/23 17:54 UTC
Read the original article Hit count: 221

Filed under:
|
|

Overview:

I have a table which stores a persons "availability" for a current day, e.g.

Mon - 8:00am - 11:30am
Mon - 1:30pm - 6:00pm

A second table stores appointments that this person already has for the same day, e.g.

Mon - 8:30am - 11:00am
Mon - 2:30pm - 4pm

Desired result:
Doing calculationsI'd like to have the following result - e.g. "this person has availability on the given day":

Mon - 8:00am - 8:30am
Mon - 11:00am - 11:30am
Mon - 1:30pm - 2:30pm
Mon - 4:00pm - 6:00pm

Any ideas on how to calculate the output given the two inputs (e.g. availability, existing appointments) would be greatly appreciated. Preferably I'd use javascript on the client to do the calculating as I would believe that doing it within the DB (I'm using MSSQL) would be slow for many records, persons, etc.

Hope this is enough information to illustrate the problem at hand - Many thanks in advance.

© Stack Overflow or respective owner

Related posts about JavaScript

Related posts about sql