Thank you all for your responses.

mister.magoo, your query appears to be giving the correct results.

Another question. Is there a way of merging rows only if they are separated by vacation?...

Just wanted to add that the queries from SSC Veteran and ChrisM@Work are the solutions I went with. Thank you.

A slightly related question. If I have the table as per the DDL below, how do I remove rows where the status is 'temp' for overlapping rows by date? In...

Hi Chris,

Thanks for your response. I will test this further.

How would I include time along with a date in the function as I completely forgot to mentioned the StartDate and...

Hi All,

Thanks to SSC Veteran's assistance, I am close to the correct result set.

During testing, I found that when 2 rows overlap, duplicate rows appear. An example is:

John Smith, Vacation,...

Hi SSC Veteran,

Thank you very much for your response.

Your DDL appears to be working. I am testing further.

The IDs for existing rows can remain the same with new IDs allocated...

Hi WolfgangE and Sean Lange,

Thank you for your responses.

WolfgangE, sorry should have been more clear in my requirements.

We have a system where an employee can be booked on a...