General information
Forum:
Microsoft SQL Server
Title:
How to propagate new keys to child table
Environment versions
SQL Server:
SQL Server 2005
I'm trying to refactor a poor DB design that has resulted in many duplicate rows. (about 80,000 rows out of 190,000 rows are dupes.
I understand how to delete the duplicates, but I am unsure how to propogate the PK of the rows I keep to children of the duplicates, IOW I'm trying to map 1 onto many.
Am I making any sense?
Thanks for any ideas.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only