It would be nice if SQL Prompt could parse CTE expressions and provide prompts just like for regular tables
This issue has been reported non-reproducable in recent versions of SQL Prompt.
John Unger commented
This happens to me all of the time. Simple procs and views are fine but probably once a week I find that the expansion just stops working or worse starts putting in system objects instead of providing the prompt for the fields available in an alias. Let me know if you want me to do some screen sharing with someone to duplicate this issue.
AdminPaul Stephenson (Admin, Redgate) commented
Hi Rad! CTEs are meant to be supported. Could you give an example where it fails for you?