Hi Sean,

I didn't have enough time to go through the query and to understand the query logic to be able to "assume" what's that all about. The two things caught my attention though; Read uncommitted session setting and Order by. The "assumption" was that we have a reasonably bad structured query that is a kind of a report that does not care about accuracy.(?) . The question was about syntax error. I couldn't help myself not to mention the nolock (and I totally agree with your previous post) mostly to highlight the possible problem.

It's almost unbelievable what you described happened with the finance app. I am seeing rbar queries, # tables flying through the zillion nested sps and so on (mostly bad programming) but noting like that..

Dean