Find Jobs
Hire Freelancers

T-SQL query for detecting duplicates in artist name and song title in radio playlist

€30-250 EUR

In Progress
Posted about 11 years ago

€30-250 EUR

Paid on delivery
I have a table "RadioPlaylist" in my MSSQL 2008 R2 database, with a field "Artist" and a field "Title", and I would like to compare each entry to a master table "Records" which has a field "Artist" and "Title" in order to retrieve the value of [login to view URL] and assign it to RadioPlaylist.number. Example: in my master table I have a record #23456 Artist: "Bob Sinclar & Cutee B" Title: "Rock the boat" I want the query to detect all records in the RadioPlaylist table. The artist can be "Bob Sinclair" or "Bob Sinclar Feat. Cutee B" and the title can be "Rock Boat" or "Rock Da Boat" The tricky part is to make the search "intelligent" so it can detect if an entry is close to the original in the reference table, with less errors as possible. SQL is 2008 Express R2, and I installed full-text search. Master Table example: [login to view URL] RadioPlaylist example: [login to view URL] The query would preferably run in a classic asp page (vbscript) so I could easily understand and adapt to my needs. Thanks Eric
Project ID: 4238125

About the project

4 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, Please check my private message. Thank you
€90 EUR in 2 days
5.0 (9 reviews)
4.2
4.2
4 freelancers are bidding on average €78 EUR for this job
User Avatar
greeting, I can do that within 1 day.
€100 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can develop the intelligent t-sql. Interested in working in this project.
€50 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi i would like to do this work
€70 EUR in 3 days
0.0 (1 review)
0.0
0.0

About the client

Flag of FRANCE
PARIS, France
5.0
14
Member since Sep 5, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.