That's what I think. Who care whether it's a single select, or uses temp tables, etc. The end result is all that's important.

Ok, so when do we get to see the submissions? The suspense is killing me.

Looking at it from a real world perspective, an overlap is an issue if a nurse has to see 2 patients at once. If the bookings are with the same patient, then that's not so much an overlap. The nurse can cover both bookings without needing to be in 2 places

I know this is the last minute, but I would imagine another requirement would be that an appointment at 2 overlapping times with the same patient is not considered an overlap.

[quote user="dishdy"] But some people claim to have a solution.And solutions are being posted. [/quote] Could that be because they have a solution that will return the same result for the supplied sample? I have one of those. However, as I stated earlie

[quote user="Jacob Sebastian"] In your example, the first and third shifts are OK and the second one is overlapping. It is acceptable to have a shift end at 10 am and start a new shift at 10 am for the same nurse. Such a case is not considered as overla

I don't believe this challenge has a logical solution. I've been looking at it and thinking it over for the last few days now, and this is the conclusion I've come to. Not simply because I can't solve it, but because of the nature of the constraints placed