Is there any way to make a single SQL Statement ... where the update statement does not fail, then you can only do that by updating row by row. To be efficient, you could use following logic ...