SELECT IDENTITY(INT, 1, 1) AS Rank,au_lname,au_fname INTO #tmp FROM authors
SELECT * FROM #tmp
DROP TABLE #tmp
SELECT IDENTITY(INT, 1, 1) AS Rank,au_lname,au_fname INTO #tmp FROM authors
SELECT * FROM #tmp
DROP TABLE #tmp