SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Finding similar records
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

slihp
Yak Posting Veteran

60 Posts

Posted - 03/20/2013 :  09:14:18  Show Profile  Reply with Quote
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

Edited by - slihp on 03/20/2013 09:49:10

bandi
Flowing Fount of Yak Knowledge

India
2206 Posts

Posted - 03/20/2013 :  09:16:51  Show Profile  Reply with Quote
Data Image is not visible to me

--
Chandu
Go to Top of Page

slihp
Yak Posting Veteran

60 Posts

Posted - 03/20/2013 :  09:49:42  Show Profile  Reply with Quote
oh dear, added a link too.
Go to Top of Page

MIK_2008
Flowing Fount of Yak Knowledge

Pakistan
1052 Posts

Posted - 03/20/2013 :  13:28:55  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000