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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Finding similar records

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 place

1) pick out the ones with simmilar names so i can i dentify what ones need there names updated
2) 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
Go to Top of Page

slihp
Yak Posting Veteran

61 Posts

Posted - 2013-03-20 : 09:49:42
oh dear, added a link too.
Go to Top of Page

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 query

SELECT RiderName,Count(1)
FROM <yourTableName>
GROUP BY RiderName Having Count(1)>1


Cheers
MIK
Go to Top of Page
   

- Advertisement -