A common SQL habit is to use SELECT * on a query ... 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 ...