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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-03 : 07:44:12
|
| Dan writes "I have very large MS SQL table with many dups in itand there is no unique key. How can I delete the duplicate records but maintain a single, most recent record. The 2 important fields that identify these records are "ID" & "LastNoteDate". the LastNoteDate field is a date & time stamp. I did see the other article on deleting the dups, but this did not address the most recent issue.Thanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
vadivels
Starting Member
1 Post |
Posted - 2005-06-03 : 08:16:12
|
| check this link :http://vyaskn.tripod.comvadivel |
 |
|
|
|
|
|
Delete Dup. records, while keeping single most recent