July 4, 2007 at 12:20 pm
hi guys,
i have a scenario here at work, a new ID # was accidently assigned to a person (who already has an ID) info in the db.
the thing is lots of info was already entered for tht new id.
is ther a way to merge the new record to the old ID info? can give an examplehow?
thx much
July 4, 2007 at 12:53 pm
List all tables where the id has been present, then depending on wether this is n-n or 1-n, then you can simply replace the new id with the old id. When there can be only 1 row per table per userid, then you'll have to manually merge the data with the persons responsible for entering that data. They will be able to tell you what info is valid and the likes...
July 4, 2007 at 1:36 pm
dang.... i wish there was an update-insert of sort.
anyway thx man
July 4, 2007 at 1:39 pm
Can't be done unless you know the system. This job is much easier to custum make than to be made by sql server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply