Thanks very much who has contributed to this thread. I really appreciate it.

Cheers,

...

Hi Rehman:

Sorry for late reply. Below reviewed table.

!-- EQUIPMENT --!------ date_start -----!------ date_end -------!

equip1 11/29/2009 06:00:00 AM 12/01/2009...

Thanks. Oracle was only a way of an example. I am implementing the thing in SQL Server 2008 R2. Do you have something about it?

Cheers,

😎

Thanks for your reply,

Data is stored in a table. I have the data in Oracle 9.2 and the resultant splitted can be a view.

Is that what you are asking about?

Thanks,...