General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>
>>So, if the codes are a relatively small number (and I'd put ZIPs in that category), I think either approach would work well. If that assumption is incorrect, then I'd agree, that populating a new cursor in the loop would be the way to go.
>>
>> Jay
>
>Yes, it was for ZipCodes. Anyway, I suspended my tests for now, so I hadn't chance to try either of suggested ideas...
When you're able to get back to it, I'll be interested in seeing what you come up with in terms of performance. If you don't mind sharing <g>.
Jay
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only