View the original community article here
Last tested: Jan 17, 2019
This is one example of an error you can get by using a CTE in a derived table. See this article for more info: Can you use CTEs (WITH syntax) in a PDT? (common table expressions, aka WITH param).