Thanks for the reply.
Not really want I'm asking about. I was wondering if anyone has a clever query to return some specific information from the calendar without having to loop through the results to determine the four possible appointment date-times and the count that
I am looking for.
Realize it may not be possible.
I can see how you can use ordering and get the top 1 to find the first and last for the day. That would be 2 queries though. A similar method mist work for before and after the slot.
Thought someone might have a clever nested query up their sleeve.