Erro 30052 - Full-text query has a very complex

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

Other SQL Server 2008 Topics

Erro 30052 - Full-text query has a very complex

Author

Topic

rafael_santos_zenite
Starting Member

2 Posts

Posted - 2012-06-14 : 15:55:25

Hi,

This is my query:

SELECT * FROM TABLE1 AB INNER JOIN TABLE2 AN ON N.id_anotacao_base = AB.id_anotacao_base INNER JOIN CONTAINSTABLE(TABLE1, *, 'word1 NEAR world2... NEAR wordN') AS C ON AB.key = C.[KEY]

This returns me:

"The full-text query has a very complex NEAR clause in the CONTAINS predicate or CONTAINSTABLE function. To ensure that a NEAR clause runs successfully, use only six or fewer terms. Modify the query to simplify the condition by removing prefixes or repeated terms."

There is another solution to put more than six terms, using NEAR?

kabon
Starting Member

48 Posts

Posted - 2012-06-18 : 23:51:20

maybe you can used inner join just like this, for example :

USE AdventureWorks2008R2;
GO
SELECT *
FROM HumanResources.Employee AS e
INNER JOIN Person.Person AS p
ON e.BusinessEntityID = p.BusinessEntityID
ORDER BY p.LastName

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources