Create Unique ID in Temp Table

[dibbo]

I am performing a SELECT.... INTO #TempTable, which works fine. However, the rows aren't unique so i'm wanting to introduce a unique ID into the first column.

Is this possible, if so how?

TIA

Dave.

 

[JohnDTampaBay]

See IDENTITY function in BOL.

SELECT IDENTITY(int,1,1) AS RowID, ...
INTO #TempTable
FROM ...

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[dbomrrsm]

SELECT *,newid()as [ID]
INTO #temp
from yourtable

[blue]DBomrrsm[/blue]

 

[dibbo]

Just what I wanted.

Thanks.

Dave.