>Realize that I will have to check for duplicate key prior to inserting a new record as that two records quickly inserted might get a duplicate key.

This will surely can be problematic if you ever use more than 1 pc to update the table, since the clocks will differ between the pc's.

You could probably get better results for 1 workstation with sys(2015) and get sortable results back by reconverting, but this can break during some time windows.

HTH

thomas