Project Description
The aim of the sqlTimeSpan data type is to allow the following queries to be logically easier to write and more efficient to execute, in a similar way to the Sql Hierarchy Data type.
The queries it aims to help are:
Assuming a resource is represented by a single key, and a reservation is a preiod of time with a start datetime, end datetime and duration:
1) show which intervals when there was no reservation for a resource.
2) detect when there is an overlapping reservation for any given resource.
3) reserve a resource on a repeating schedule and be able to include it in query 1 and 2.
The sample code curently consists of some test data to allow us to explore these requirements