Inserting a value from one row into another

[goofaholix]

I have an Impromptu report which returns a list of rows that contain a start date and an end date.

However the end date is not populated.

If I were to group the data by Employee and order it by start date I wondered whether there is any way to grab the start date from row 2 and insert it into the end date field or row 1, and so on...

I presume I can't do it with Impromptu, and if it's doable at all I'll need a stored procedure with a temp table, and maybe use cursors.

Any ideas?

Thanks.