Thanks for the quick reply and suggestion...within the stored proc, I wrapped the insert in an explicit transaction but the results are the same. The lookup for the second row...