Once it passes those validations, no more errors are expected and you can pump it over in one statement (well, could be an insert, a delete and maybe even a delete) to the final table.