Re: Impossible SQL query?

You're right, I just finished the procedural code for this and it goes pretty quickly. In cases where there are a lot of rows (25,000 or so) it can still process the data in 15-20 seconds on a pretty slow processor. I'm pretty happy with that, especially considering I have to wait much longer just to get the records from the database to begin with. I guess I was scared off by the previous guy's code, he did everything procedurally and it runs incredibly slow. I managed to convert most of it to SQL but this one problem got me stuck. I guess it's not possible to convert *everything* to SQL. :P

Well, thanks for the help everyone, I really appreciate it. I can see that there are a lot of smart people in this newsgroup, this is definitely going in my bookmarks! :)

-jay Received on Wed Oct 05 2005 - 15:52:40 CDT