Full text indexing is sql server 2000
-
Hi, I am using fulltext indexing for searching for a list of values in a given text field(which contains description). For example this is my query. select * from details where contains(description,'"manager" or "sales manager" or "zonal manager"') Now I have the second part of the contians in another table. i.e '"manager" or "sales manager" or "zonal manager"' is stored in another table. But when I am giving select statement in the second part of contains it is giving me an error. How to search for description by taking values from another table with out using loops and in a single query. If I am using cursors and performing the search it is taking lot of time.How can I speed up? Regards, Uma
-
Hi, I am using fulltext indexing for searching for a list of values in a given text field(which contains description). For example this is my query. select * from details where contains(description,'"manager" or "sales manager" or "zonal manager"') Now I have the second part of the contians in another table. i.e '"manager" or "sales manager" or "zonal manager"' is stored in another table. But when I am giving select statement in the second part of contains it is giving me an error. How to search for description by taking values from another table with out using loops and in a single query. If I am using cursors and performing the search it is taking lot of time.How can I speed up? Regards, Uma
I'm not sure i entirely understand your question, but can you not join onto the other table in the query?