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 - 2004-06-08 : 08:07:05
|
| Jake writes "I looked at your Delete Duplicates post but it doesnt exactly fix my problem.What I have is Rows that are completely identical Anywhere from 1 to how ever many memory can hold.How would I delete just one of them?" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-08 : 08:24:32
|
| Perhaps add an identity column to the table and then delete by that column, otherwise I don't think you can... |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-06-08 : 08:29:10
|
| Do you mean "delete just one of them" or "all but one of them"? If it's the first, you can use SET ROWCOUNT 1 and then run the delete. For the second, see the article.OS |
|
|
|
|
|
|
Delete Distinct ?