Michael

That one returned me two identical records that overlapped an existing case.

Current Data:

RoomID      BeginTime                EndTime
14          01/25/2002 07:30         01/25/2002 08:25
14          01/25/2002 08:33         01/25/2002 10:28

The result set returned:

RoomID       BeginTime              EndTime
14          01/25/2002 08:26        01/25/2002 09:26
14          01/25/2002 08:26        01/25/2002 09:26

Kirk