David,

I tried this query

UPDATE detail_data1

SET time = DATEADD(ss,T.ID-DT.FirstID,GETDATE())

FROM detail_data1 AS YT

INNER JOIN detail_data1 AS T ON YT

INNER JOIN (

SELECT person_id, date, time, item, visit_id

FROM ...

It is a not a problem with new records being added - the load program has since been changed to accomodate that. It is only a problem with the...

Hi Strick

Thanks for the reply. Unfortunately I am restricted to the fields currently defined in the table, I cannot add another field like the indentity. The time field does...