Can with (UPDLOCK, ROWLOCK) help against deadlocks in this situation I have a table tblImportData that looks like this