Is there a way to create a column, in a select statement, which has an
identity.

At the moment, I am selecting from a table into a temp table and then
inserting and identity row.

Is it possible to do this in the select statement on the fly?

Thanks guys,



MS Sql Server LazyDBA home page