Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-03-30 : 13:24:32
|
show me the light! I have 5 tables that have an OldID column and a NewGUID column.I also have an old History table and a new History table.The old History table links to the 5 OldIDs.The new History table links to the 5 NewGUIDs.How do I populate the new History table with the NewGUIDs in one INSERT statement? |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-30 : 16:46:02
|
| It would be easier for us if You posted the actual table structures.And maybe some sample data?rockmoose |
 |
|
|
PW
Yak Posting Veteran
95 Posts |
|
|
|
|
|
Trying not to use cursors, guide me