SQL Server Containstable issue


Hi experts,
I replaced my contains statements in our FT Search with containstable statements.
Containstable seems to run much faster in our case.
My problem is that searching for "word1" return a specific ID.
Searching for "word2" retuns the same ID.
Searching for "word1" and "word2" dont find that ID.

Due to our programm functionality this is very important for us.
Any ideas?

select * from containstable(tblName, (txt,syn),  '"DARM*"' ) as FT_TBL
order by  FT_TBL.[Key]
Result:
Key                                    Rank
...
8455683147005	10
 
 
select * from containstable(tblName, (txt,syn),  '"MG=10ST*"' ) as FT_TBL
order by  FT_TBL.[Key]
Result
...
8455683147005	64
 
select * from containstable(tblName, (txt,syn),  '"DARM*" AND "MG=10ST*"' ) as FT_TBL
order by  FT_TBL.[Key]
 
No results!!!

Open in new window

duke63Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
could it be that 1 part (say DARM) is in txt field, and the other part "mg=10ST" in the syn field ?
that would explain the results...
0
duke63Author Commented:
hi angellll,

that is correct.
I didnt expect that behavior.
Any idea how to handle this with containstable?
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I presume, like this:
select FT_1.[KEY] 
from containstable(tblName, (txt,syn),  '"DARM*"' ) as FT_1
join containstable(tblName, (txt,syn),  '"MG=10ST*"' ) as FT_2
  ON FT_1.[Key] = FT_2.[Key] 

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
duke63Author Commented:
thanks a lot angelIII !!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.