Inserting data using column numbers
Posted on 2015-02-11
Would it be possible to insert data from another table using column numbers. We have a reference table that holds the column numbers together with the corresponding column header value. The reference table is as follows:
Name VARCHAR (30)
We would also like to be able to insert the corresponding Name value into the target table together with the other info.
Target Table is as follows:
Results VARCHAR (50).
It would probably mean an UPDATE statement, as the target table is already populated with IDs, dates, etc from the source table. Unless there is a way to INSERT the whole line at once.
Any assistance would be appreciated.