w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
copy parent-child data to another table with different parent-child ids

Either a cursor or a temp table should work--if it's a one-time copy and performance is not a concern, I would just choose whatever you are more comfortable with.

If you have other ways of uniquely identifying the rows, you may have other options as well.

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.