sql server - In MS-SQL, how do I INSERT INTO a temp table, and have an IDENTITY field created, witho

I need to select a bunch of data into a temp table to then do some secondary calculations; To help make it work more efficiently, I would like to have an IDENTITY column on that table. I know I could declare the table first with an identity, then insert t

stackoverflow.com