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 - 2006-08-09 : 09:15:28
|
| Rajarajan writes "Kindly don't ignore this as regular case.This is peculiar.I need to delete one of duplicate records only if they occurs consecutively.eg.1. 2322. 2323. 3454. 5675. 232Here only the first record has to be delete. Kindly help me out.Thank you.Regards,R.Rajarajan" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Deleting 'consecutive' duplicate records alone 