I am currently facing a dilemma based on our SQL Server host and our business requirements.
The company would like to establish a hierachy of words in which a person can search.
If tier one was "web developer" and tier 2 was "ASP.NET" and tier three was "VB.NET" - any searches with web developer will bring results containing ASP.NET and VB.NET. Conversely if you were to search on ASP.NET you would not get web developers but you would get VB.NET programmers.
Our host doesn't allow us to have a XML file of the Thesaurus entries so we cannot use that and the other part of this is that there are many clients in our database. They have to only be able to search their results (which I have covered with a client ID).
Please give me any input on how we can search these tables for skillsets and have the results returned quickly (excellent execution plan) and follow the above rules.
Thanks in advance,