Partial Matching the Columns
-
Hi All,
How could I partially match the columns from two different table. I have attached the excel sheet for reference.
-
SELECT CompanyB.Value SourceValue, CompanyA.Value PartialMatch
FROM CompanyB
Left join CompanyA
on CompanyA.Value like '%'+CompanyB.Value+'%' -
This was removed by the editor as SPAM
-
Its not executing it. I have attached the separate table.
I want to match from TableB
-
If you want really good help, then see the article at the first link in my signature line below for one of many ways to provide example data in a readily consumable format.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply