Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  Help optimising a full-text search

Author  Topic  dgb2009 Starting Member 3 Posts Posted - 2009-09-19 : 05:26:14 Hi, I've got the following query that uses a full-text index to search for the TOP 5 products (from the RawProducts table) matching the query, in a given Shop (populated by the @ShopId variable). At the moment I'm calling this procedure over and over again for every ShopId (there are 27 Shops) - which is a bit slow. My question is - could anyone let me know how to modify the query to accept, say, a comma-separated list of ShopIds in the @ShopId variable, and to return the TOP 5 matches from each shop? Here's the query so far: DECLARE @ShopId uniqueidentifier SET @ShopId = '49506541-4ce2-40ac-812a-7ab262e6f0b0' SELECT TOP 5 ftt.RANK, rp.* FROM RawProducts rp INNER JOIN CONTAINSTABLE ( RawProducts, RawProductName, 'ISABOUT("*radox*","*shower*")' ) AS ftt ON ftt.[KEY]=rp.RawProductId WHERE rp.ShopId = @ShopId ORDER BY ftt.RANK DESC Really appreciate your help! :-) thanks!