>If you're using SQL Server 2000, use a table variable instead of the temp table
>

Nope... I'm using SQL7

>Make sure that you have an index on _links.link_id.
>
Since it's the table with the full-text index it has link_id as the primary key. Do I need to add another index?


>Text manipulation is not SQL Server's strength. Build the HTML table somewhere else.
>

I definitely will...


>Can you provide an execution plan?
>

I'd like to but I'm not sure how... I ran the SP in hte Query Analyzer wirh Execution Plan set on, however I do not see a way to grab the results and set them over.

Please advise....

Thanks for the help,
Mike