The simple approach would be to insert your SELECT statement into a temp table.

Then have a final SELECT from this temp table with the filter you desire.

Give this a try...

Definately upgrade to SQL Server 2000. Don't wait, do it immediately.

Several features will make your routine run instantly. You would be able to have a computed column in...