1

I need some advice/ideas.

I have a table containing job announcements approx. 250,000 records

In another table is 6000 keywords/sentences from applicant cv's historically regarded by the government as typical

I want to find job announcements where the text contains one or more of the keywords

I have been doing this, using full-text-search, but firstly, the variable, can´t hold all keywords and secondly it is very slow

DECLARE  @Keywords NVARCHAR(MAX)

SELECT   @Keywords = STUFF((SELECT '|' + Word
                            FROM  dbo.Keywords
                            FOR XML PATH('') ), 1, 1, '')

SELECT *
FROM   dbo.Notes
WHERE  CONTAINS(Note, @Keywords)

Do you have any bright suggestions of how to solve this challenge ?

1

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.