Forum Discussion

rpreddiz123's avatar
rpreddiz123
Copper Contributor
Mar 28, 2024

an expression services has been reached

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?

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor

    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.

Resources