The one place I actually need this is when a procedure has not yet been deployed to Production, and a customer wants the output it produces. Example: sales details...
You CAN, however, build an update VIEW that includes an INSTEAD OF TRIGGER, allowing you to update more than one TABLE from the CTE through the VIEW, based on more...