The better solution for such a massive operation is to use an inline CASE statement in the query to set the column value, during the insert operation itself.