Re: Internal query processor error

Zvonko Bi¹kup (zbiskup@gmail.com) writes:
> I am trying to execute rather complex query, and I got query processor
> error. I read the Microsoft support page and it said I should install SP4,
> and I did, but the error is still there.

There are probably more than one way to achieve an internal query
processor error, so even if they fixed one issue or two in SP4, it does
not mean that they fixed them all.

Without seeing the query or the database, the only advice I can give is
to try to break up the query in pieces, possibly storing intermediate
results in a temp table.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx