Please review the attached Excel Sheet. There are three sheets defined.
Table 1 - Three Columns Trade_Name(Varchar(50)), CID (int), Strength (VarChar(50))
Table 2 -Contains One Column [DG DRUG NAME](VarChar(50))
Result Format - Desired result from matching the results from table 1 and table 2
There are two deliverables for this project
1) provide a mappig table matching the records from the first table into the second table (Result Format Sheet)
2) provide a SQL Server function to return the CID from table 1 based on [DG Drug Name] from table 2
Data is not very clean an 95% success rate is acceptable but higher the better.
21 freelancers are bidding on average $96 for this job
I am interested in this project. I have 6 years of work experience in the information technology field, especially on databases - sql, mysql. I hope to hear from you.