Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating A Column In A Table
- Thread starter cohibaman
- Start date
SantaMufasa
Technical User
First, please explain what business benefit there is for having two identical records in a table? That actually is a relational-concepts "No no". If you can offer a good business rationale for two identical records, I'll be glad to explain how to update one and not the other.
More appropriately, I'll be glad to explain to you how to get rid of duplicate records, leaving one unique record.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 17:16 (23Sep04) UTC (aka "GMT" and "Zulu"), 10:16 (23Sep04) Mountain Time)
More appropriately, I'll be glad to explain to you how to get rid of duplicate records, leaving one unique record.
Mufasa(aka Dave of Sandy, Utah, USA @ 17:16 (23Sep04) UTC (aka "GMT" and "Zulu"), 10:16 (23Sep04) Mountain Time)
- Status
