Uglier than having to find the record after the one you're inserting (so you can determine your new record's end date from the subsequent record's start date) a

Uglier than having to find the record after the one you're inserting (so you can determine your new record's end date from the subsequent record's start date) and the record before (so you can modify its end date to match your new record's start date)?