Home Dashboard Directory Help
Search

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


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


1
1
Sign in
to vote
Type: Suggestion
ID: 789949
Opened: 6/11/2013 4:51:02 PM
Access Restriction: Public
0
Workaround(s)
view

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
Details
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
Sign in to post a workaround.