Data Mapping

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.