I'm glad you sorted it out.
>
>All excellent questions. I altered my approach and made the ISBN13 a unique index and I am attempting an insert first and only doing the update when an error is fired. After making this change the process went from 10 days to 5 hours for 4,000,000 records.
>
>BTW I corrected the error in the directory reference. I agree a stored procedure would be superior, since this is a 1 shot I figured quick and dirty, just not this dirty.
>
--sb--