Käynnissä

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

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 [url removed, login to view] 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: [url removed, login to view]

RadioPlaylist example: [url removed, login to view]

The query would preferably run in a classic asp page (vbscript) so I could easily understand and adapt to my needs.

Thanks

Eric

Taidot: ASP, Tietokannan hallinto, SQL

Näytä lisää: search artist, radio reference, playlist com, master my song, vbscript for, t-sql with, t-sql in, search for artist, i want to be an artist, artist search, t-sql;, SQL Query, sql duplicates, query table, playlist, classic name, boat name, artist name search, sql retrieve table, sql search asp, vbscript com, asp sql search, classic asp table search, title number, sql express installed

About the Employer:
( 14 reviews ) PARIS, France

Projektin tunnus: #4238125

Myönnetty käyttäjälle:

truongngocthanh

Hello, Please check my private message. Thank you

90 € EUR 2 päivässä
(9 arvostelua)
4.2

4 freelanceria on tarjonnut keskimäärin 78 € tähän työhön

vishalw84

greeting, I can do that within 1 day.

100 € EUR 1 päivässä
(0 arvostelua)
0.0
urfreelance

I can develop the intelligent t-sql. Interested in working in this project.

50 € EUR 2 päivässä
(0 arvostelua)
0.0
SoftwareParadise

hi i would like to do this work

70 € EUR 3 päivässä
(1 arvostelu)
0.0