A STRANGE QUERY

Dear List,

I have a very strange query:

The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system.
It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated. Received on Mon Jan 12 2004 - 14:54:27 CST