SQL-Sever The query processor ran out of stack space during query optimization.

Server: Msg 8621, Level 17, State 93, Procedure pSaleovINN, Line 14
Internal Query Processor Error: The query processor ran out of stack space during query optimization.

 

Queries that contain a large number of  IN or a NOT IN clause may generate a stack overflow.

Solution: Rewrite query with temp table.

 

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