Compare values in different rows for date/time clashing

Trigger would be right way to implement this. Another way is to use your function in a CHECK constraint, which will implement this restriction.

---

Satish Kartan www.sqlfood.com