Hi I have a problem while filtering my data.
I have two tables one is the main table where all the data is stored. There is another table where the keywords are stored which is required to filter data from Main table.
The problem i am facing is that i am not able to put up the exact query which is required as the keywords which arrive in the Main Table Data are required to be filtered out.
For example if there are 10 words in Keyword table then Main table data have to be searched thorough all these keywords so that it can be filtered out correctly.
I have a query but it goes in nested loop i want a better one.
I hope i have made the question clear.
Also i am using LINQ TO SQL solution in it is most welcome