an extra vote for Andrew's solution since it allows index usage

is connection pooling on/off?

We had troubles with connection pooling off resulting in error messages like server does not exists... because the machine couldn't generate connections fast enough (or something alike)

functions on columns that participate in the join can make the optimizer decide not to use an index (not sargeable)

like convert(varchar(10),mydate1,102)=convert(varchar(10),mydate1,102)

adding Trusted_Connection=true  means it needs to be windows authenticated.

Second, connecting as sa is a very serious security risc. I hope sa has a password.

found a kb article that might apply: (for standard edition)

http://support.microsoft.com/kb/316749/

Otherwise, are you profiling any performance counters?

found a kb article that might apply: (for standard edition)

http://support.microsoft.com/kb/316749/

Otherwise, are you profiling any performance counters?

select ...

from table1

where not exists (select PERMIT_ID from table1 table_bad where table1.PERMIT_ID=table_bad.PERMIT_ID and table_bad.PERMIT_EVENT_DT is null)

If could be rewritten to replace not exists, by some form of counting those whose...

Thanks for posting the solution.

Is it possible to post a link describing the issue with the cpu?

In such situations it is always helpfull to compare the execution plans of the queries, you can do this via the query analyzer: (Query) show estimated execution plan.

Possible reasons: the...

Looks your tempdb is running full or it can't grow fast enough.

Can you split your command in batches of 100 000? With a counter or something to remember the highest...

Raid 5 isn't particulary recommended if there is a lot of writing activity. Looks splitting it up would be ideal. Can't say more since the largest raid I have are...

not sure if it will work, but you will need an error check too at

OPEN C_TESTE

 FETCH NEXT FROM C_TESTE  INTO @CONT

->error check

Can you give some textual output data?

Some things that might improve:

Union -> Union All

Rewrite CONVERT(varchar(10),ud.[date],110)=CONVERT(varchar(10),i.[itdate],110) to use BETWEEN instead of performing a function on a column

Does it work when you write a parameterquery (as a query object) and use that query for the recordsource?

Is vwIndivPTMFcastbyProject a linked table or do you

use T-SQL?

Can you output debug.print strSQL or msgbox strSQL to verify strSQL?