an expression services has been reached

Copper Contributor

Hi All,

I am using the simple case statement in my CTE's not sure why but i am getting this error

an expression services has been reached

With CTE1 as 

(

),

CTE2 AS

(

),

CTE3 as 

(

)

I only have 3 values in with the case like below

case when [Name1]='CR' THEN 'QA1'

        when [Nam1]='MR' THEN 'QA2'

       when [Name1]='BF' THEN 'QA3'

else 'not mapped

end as Testing

 

not able to figure out the reason why?

 

1 Reply

@rpreddiz123 , you posted only "empty" SQL fragments, so no one could even guess.

The complete error message is

"Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them."

 

So as the error message says.