Forum Discussion
rpreddiz123
Mar 28, 2024Copper Contributor
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?
- olafhelperBronze 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.