[RESOLVED] INSERT INTO without field names

[alex_read]

Here's my 2 cents if I were approaching this problem.

• Temporarily store the destination table field names
• Temporarily store the source table field names
• Perform a lookup & marking/store the matching fields (instr, nested loops etc.)
• Copy the source table into a destination_Staging table
• Perform any extra data manipulation, your maths calculations on the data etc. within this table
• Look to write to a log table if you've many client files to process at once. I.e. info such as "at x date and y time, customer a's data was uploaded. It didn't have source columns b and c that the destination table has. Of 1000 rows, 1000 were successfully copied." (for either you to fix, or shoot back to the client to help fix before another try).
• Depending on the results, decide either to make a copy of this table to later come back to, or then perform the movement (copy then delete) of data from the staging destination_Staging table to the destination table