When running the query profiler on a query that contains CTEs, the results are not accurate and the Explain Plan section does not appear in the profiler tree.

To profile queries with CTEs I have to re-write them as subqueries which is a waste of time and makes it more difficult to read.