Friday, February 25, 2011

Create temp table with identity instant select statement

SELECT SequentialRowNumber = identity(INT,1,1),ROW_NUMBER()
        OVER (ORDER BY CustID) AS Row,* into mytit1 from #customers

No comments :

Post a Comment