There are a lot of examples on this website showing you how to do this.  The temp table method is best, as no dynamic SQL is required.  I have two...

Have you read this http://support.microsoft.com/default.aspx/kb/176256 regarding disabling asynchronous mode?

Are you using Enterprise Manager to view processes? A process with two open transactions is normal.  Also, KILL 63 with statusonly will display a status report only when a transaction...

JOIN is part of the FROM clause. That is followed by the WHERE clause, which can have multiple NOT Contains().  Whether you connected them with OR or with AND would...

It appears you're finally getting close to your solution. Regarding the question about NOT ( your example: Author but NOT title ), since the NOT column (title in this case)...

Returning to your original method, here is one way to do it:

DECLARE @filepath varchar(300)

      , @cmd varchar(300)

      , @prevPos int

      , @pos int

--EXEC master..xp_cmdshell 'copy...

This is best handled by the application that opens the connection. However, if you are using Query Analyzer, for example, then that is not possible.

You could try running a query...

You mentioned you had duplicates using the first FreeTextTable. UNION eliminates dupes, so I'm not sure what you mean.

1. To combine the result sets and eliminate duplicate rows (that is,...

You mentioned sorting by rank. Did you try using FreeTextTable()? That returns rank information - Freetext() does not.

Here's an example:

DECLARE @search varchar(100)

SET @search = 'Bonnie'

SELECT FT.Rank

     ,...

First of all, I would discourage using column names like [Last Name - 1].

Freetext() only works on columns that have been registered for full-text searching. You can't use a computed...

The query layouts I mentioned in my earlier replies regarding derived tables include many different structures. Here is one:

SELECT n.pkey, n.subject

  FROM status n

  JOIN (SELECT pkey

          FROM documents

        ...

SELECT ....

  FROM YourTable

 WHERE Freetext(column1, 'search_string')

    OR Freetext(column2, 'search_string')

    OR Freetext(column3, 'search_string')

...

Does this situation apply in your case?

http://support.microsoft.com/kb/257425/EN-US/

Your WHERE clause can use multiple CONTAINS(), if necessary, possibly separated by OR. You could also union queries together. Or, run one or more queries as derived tables - providing the...

This example will change all occurrences of "&" to "&" for all rows.  Another way is to read blocks of 4000 characters at a time into a local variable using...