I'm trying to use SQL full text search (SQL Server 2008) to match rows of information in two different tables with a cursor. Essentially what it should do is take product "A" and product "B" and see if they're of the same product family.
Example: A = "Windows Server 2003". B= "Windows Server 2008". <--this would be a match.
Example2: A = "Windows 7". B="Windows Server 2008" <--this would NOT be a match. I've constructed a Theasarus and am using the Contrains(FORMSOF(Theasarus,product)) and it appears to work to an extent. However, it is matching "Windows 7" with "Windows
Server [edition]" products. Below is my code and Theasarus.
Thanks for the help!
declare @FTSproduct nvarchar(255)
declare @FTSwrappedProduct nvarchar(255)
declare @FTSformsOfProduct nvarchar(255)
declare @TechnologyName nvarchar(255)
View Complete Post