I was thinking of going the same place you're saying, Ben. Yes it does complete with a smaller subset. I was thinking of adding a column to the table that I can mark with an "X" after the cursor completes, have the cursor say "where flagcolumn is null" and have it quit after say 10,000 rows. Yeah, kind of a pain in that someone would have to exit RBase, come back in and start it again (would also for sure have to turn it into a permanent table).
Karen In a message dated 8/10/2012 9:30:00 AM Central Daylight Time, [email protected] writes: > Hi Karen, > > Have you tried reducing the data to ~2/3s the original to see if it will > actually complete? If that works, maybe note how much can be done at one > time and set the routine up to restart every X rows. That would be a pretty > tacky work-a-round but it might give you a place to start. And if the routine > won't actually complete using a smaller data set, then you'll know it's > not the quantity of data that is the problem. > > Ben
