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 |
|
pgmr1998
Yak Posting Veteran
66 Posts |
 Posted - 2011-02-15 : 13:55:15
|
| I am trying to update a field in a db table, but one of the rows have a legitimate duplicate record. I don't want to update the duplicate record when I apply the update. How can I perform an update to only one of the records when both contain the same values in all fields.I am using SQL 8.00Should I use Enterprise Manager instead of Query Analyzer? |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-15 : 14:23:44
|
| in your query's condition use not exist e.g. Where (conditions) and not exists(select ... group by a having count(*)=1) |
 |
|
|
|
|
|
Duplicate Record Elimination in Update