Hi, Jeff--

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...

At the direction of an expert, I am putting this question onto Stack Exchange. Thanks.

You don't actually need to name the PK:

CREATE TABLE #Test (ID INT IDENTITY);

ALTER TABLE #Test ADD PRIMARY KEY CLUSTERED (ID);

- or -

CREATE TABLE #Test

(

ID INT IDENTITY

, SomeCharVal CHAR(10)

,...

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...