September 30th, 2003, 11:55 PM
Help with traversing a HUGE table
First I apologize if this is a basic question. This is all fairly new to me.
I am attempting to extract data from a table with 6 million plus records. With each record I qury several other tables and then submit to a new table. It works great when I select the top record. My problem is that I need to traverse the entire table.
I use cursors in other parts of the script but think that trying to use a cursor on a 6 million record table is a little stupid.
Does anyone have some advice on a different way?
Thanks in advance!
October 2nd, 2003, 09:36 AM