Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>
>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement