Thursday, February 14, 2013 11:40 PM
I have two tables with identical structures. One table has the historical records and one is the current, in use table with only a couple thousand records.
I would like a query something like this,
insert into myHistoricalTable (select * from recentTable where uniqueCol = 'TAS')
But I am pretty sure I can't do this in this way.
How might I do this?
Thursday, February 14, 2013 11:48 PM
Similar question was asked this morning -
INSERT INTO DB.SchemaName.myHistoricalTable (Col1,Col2...) SELECT Col1,Col2... FROM DB.SchemaName.recentTable WHERE uniqueCol = 'TAS'
- Marked As Answer by danielsn Friday, February 15, 2013 12:03 AM
Friday, February 15, 2013 12:04 AM
I did look for similar posts with the search, but didnt just look through the last ones.