DECLARE @counter INT;
      @counter = 0;
 
      CREATE TABLE #temp (counter int, otherdata varchar(255)) --Use whatever columns you need.
 
      DECLARE tempCursor CURSOR FOR SELECT * FROM table
      OPEN tempCursor
 
      DECLARE @value AS INT --or whatever your datatype is
 
      FETCH NEXT FROM tempCursor INTO @value
 
      WHILE @@FETCH_STATUS = 0
      BEGIN
 
      INSERT #temp (counter, otherdata) VALUES (@counter, 'otherdata')
      @counter = @counter+1
 
      FETCH NEXT FROM tempCursor INTO @value
      END
 
      CLOSE tempCursor
      DEALLOCATE tempCursor
 
      SELECT * FROM #temp
 
      DROP TABLE #temp