Home Forums SQL Server 2005 T-SQL (SS2K5) Inserting value for identity column in a temporary table RE: Inserting value for identity column in a temporary table

  • If the FROM table ALSO have identity Column then what we do ?

    I am Facing this Problem ..

    SELECT IDENTITY(int, 1, 1) AS 'RowID',* ,ROW_NUMBER() OVER(PARTITION BY UID ORDER BY ID ) AS RN,ROW_NUMBER() OVER(PARTITION BY UID ORDER BY ID)-1 AS RNL

    INTO #temp

    FROM Temp1

    RowId--->Identity IN #temp

    ID------->Identity IN Temp1

    Here Iam Getting The Error like

    Msg 8108, Level 16, State 1, Line 3

    Cannot add identity column, using the SELECT INTO statement, to table '#temp', which already has column 'ID' that inherits the identity property.