Viewing post 1 (of 1 total)
If you define your temp table just make the column in question an Identity column.
CREATE TABLE #temp Col1 int IDENTITY(1,1), col2 <datatype>...
Then just dont include this column in your insert...
November 14, 2005 at 6:38 pm
#603798