SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
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  

Yak Posting Veteran

61 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


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

Flowing Fount of Yak Knowledge

2240 Posts

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

Go to Top of Page

Yak Posting Veteran

61 Posts

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

Flowing Fount of Yak Knowledge

1054 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

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.05 seconds. Powered By: Snitz Forums 2000