Thanx Criag. I appreciate all you ppl in this post time.

This was the first post so went wrong. Next time will be in appropriate forum.

Unfortunatly i have to do this on MS SQL 2000. So can i have the equivalent for MSSQL2000 please.

Nope. it will be in order by Emp_ID and no missing rows. If the Emp has no end date which means still continueing.So there will be only one row with...

Hi Thanx for Reply...

Yes based on Emp_ID and start date. It is like the row follows with end date or if end date not there then next row will have...