Updateable CTEs

(Kenneth Fisher) CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t overly well known is that you can actually update the data within the CTE.

Read More – Register for a Membership