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 |
|
slihp
Yak Posting Veteran
61 Posts |
 Posted - 2013-03-20 : 09:14:18
|
I have a list of race results that have been imported into a table. some have miss-spelled names, wrong board numbers and licenes. I want to in the first place1) pick out the ones with simmilar names so i can i dentify what ones need there names updated2) once i have the names sorted i cna then takle the board numbers and licences http://i1057.photobucket.com/albums/t385/yeti_71/untitled_zps2fae4fa1.jpg |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-03-20 : 09:16:51
|
| Data Image is not visible to me--Chandu |
 |
|
|
slihp
Yak Posting Veteran
61 Posts |
Posted - 2013-03-20 : 09:49:42
|
| oh dear, added a link too. |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-03-20 : 13:28:55
|
| If you need to find duplicates (similar names) you may use this querySELECT RiderName,Count(1) FROM <yourTableName>GROUP BY RiderName Having Count(1)>1CheersMIK |
|
|
|
|
|
|
Finding similar records