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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-22 : 08:40:39
|
| Vikas writes "I have a table called article. Full Text Search has been enabled on three columns called art_text,art_heading and art_summary. I am using containstable to search some keyword into first two columns i.e. art_text and art_heading. Also i need to retrieve some other data from other columns, so i have a complicated sql statement like this :SELECT distinct art_id, <another subquery>, ( ct_at.[rank] * .1 + ct_ah.[rank] * .08 end )/2) as trank FROM containstable(article, art_text, '("Hello*" AND "ONLINE*")' AS CT_AT,containstable(article, art_heading, '("ATC*" AND "ONLINE*")' AS CT_Ah,article art, article_link al Where ( CT_AT.[KEY] = art.art_id or ct_ah.[key] = art.art_id) and<rest of the query>Since it calculates two ranks, so based on that, it returns duplicate rows for art_id. i don't want to use *, since i don't want to look at the art_summary column in this query.Any advise will be quite helpful.thanks" |
|
|
|
|
|
|
|
ContainsTable