Create Table Variable (or Temp Table) from an existing Table but with an Extra Column

Question

I want to create a table variable or temporary table, using data from another table but with an extra column.

I know I could use SELECT INTO as follows

SELECT *
INTO #TempTable
FROM Existing_Table
WHERE Section = 2

and then use

ALTER TABLE #TempTable ADD New_Column

And finally

DROP #TempTable

I will then be looping through each row with a dynamically called stored procedure to place values in the new column. Its not a big table.

Is that the best way? My understanding is that I cannot use the above with a table variable.

Thanks

Chris.

Oleg Dok · Accepted Answer · 2012-03-01 04:48:35Z

4

Its simpler

SELECT *, cast('hbkkj' as nvarchar(100)) as New_Column
INTO #TempTable
FROM Existing_Table
WHERE Section = 2

answered Dec 29, 2011 at 12:51

Oleg Dok

21.9k4 gold badges48 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1