I accidentally deleted a column out of a table in my production DB. (I know slap me for doing that) I now need to rebuild that.
I have a Backup DB from older data that I can use to insert the data into the production table.
Both tables are schemed the exact same way. I need column LINEHAUL_PAID copied to LINEHAUL_PAID in production table.
I need to move data from the old table/column and repopulate the current table/column... catch is it has to match with a LOADNUMBER. So I am unsure how to properly insert into with a proper where clause where the LOADNUMBERs match. There have been records added since the original backup was made and don't want to lose that info.
I'm sure this is a simple thing, but being I am writing into the production DB I need to be absolutely certain not to screw this up anymore.