SQL - increase 'expression services limit' for complex/nested IN clauses - by Mike Honey - Manga Solutions

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
1
Sign in
to vote
ID 789949 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 6/11/2013 4:51:02 PM
Access Restriction Public

Description

A SQL SELECT statement with an IN clause which refers to a view which itself has many IN clauses can produce an error:

Error 8632:

Internal error: An expression services limit has been reached.

This behaviour is described in:
http://msdn.microsoft.com/en-us/library/ms177682.aspx
http://support.microsoft.com/kb/913050
Sign in to post a comment.
Posted by Microsoft on 7/17/2013 at 1:08 PM
Hello,

Thank you for submitting this feedback. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.

Thanks again for providing the product suggestion and continued support for our
product.

Sincerely,
Manbeen