I would like to write a SQL query in a SQL Server stored procedure so that the result will not have duplicate rows. I have a table containing the following fields

```
ArticleId, Topic, Introduction, ArticleText, TagsAndKeywords 

```

(`TagsAndKeywords` are some info to make search easier)

Suppose the user is giving a search for "Best practices in SQL".

Then the query should do 

1. a full text match in `Topic` first, `Introduction, TagsAndKeywords & ArticleText`
2. split the search text (here 4 words) and search it inside `Topic`, `Introduction`, `TagsAndkeywords` and `ArticleText`

I want to get a single table without duplicate rows. Please assist me to solve this

Thanks