Retrieve One Row At A Time

Hi,

I am going to be difficult here... How do I retrieve one row at a
time from a table without using a cursor?

For example, I have a table with 100 rows. I want to retrieve the
data from row 1, do some stuff to it and send it on to anther table,
then I want to grab
row 2, do some stuff to it and send it to another table.

Here is how I am envisioning it:

WHILE arg1 < arg2 {arg1 is my initial row, arg2 would be by total
rowcount)
BEGIN
SELECT * FROM [TABLE] BUT ONLY ONE ROW
.... MANIPULATE THE DATA
INSERT into another table
END

Other notes, I am using SQL Sever 2000....
Thanks and in advance and as always the help is greatly appreciated.

Regards,

CLR