"Chris" <chris@dagran.com> wrote in message
news:736fadb1.0309301643.572f3730@posting.google.com...
> 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

>
> 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.

> I want to thank you both for your answers they have helped
> tremendously. We are going to use a cursor for our problem as well, I
> just wanted another way of handling what we are triyng to accomplish.
> We have a table with over a million rows, which from one row we will
> query about 5 other tables to extract more information which will be
> sent to a new table, then we grab the next row and so on and so forth.