Cursorless Cursor

/*Create temporary table using SELECT INTO statement*/DECLARE @I as int,
@Row_Count int,
@au_id char(11),
@au_lname varchar(50),
@au_fname varchar(50),
@phone varchar(15)

SET @I = 1

SET NOCOUNT ON
SELECT 
IDENTITY(int, 1,1) AS ID_Num,
au_id, au_lname, au_fname, phone
INTO #TempTable  FROM authors

SET @Row_Count = (SELECT COUNT(*) FROM #TempTable)

WHILE @I <= @Row_Count 
BEGIN
/*Simulate fetch statement*/SELECT @au_id = au_id, @au_lname = au_lname, 
@au_fname = au_fname, @phone = phone 
FROM #TempTable WHERE ID_Num = @I
/*Show the result*/SELECT  @au_id AS [AuthorID], @au_lname AS LastName, 
@au_fname AS FirstName, @phone AS Phone

SET @I = @I + 1
END
DROP TABLE #TempTable
SET NOCOUNT OFF
GO