Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi!
>
>Insert a list of values into some temporary table before the query. Than use IN (SELECT ...) in youre WHERE clause. In other words, instead of comma-separated list of values provide a SELECT statement.
Hi Vlad,
I can use a local cursor OR table in an SPT statement as a referance? I was not aware of this. I will look into this. I tried something else, I did: CUST.cust_no IN ( listed 20 cust no's ) OR CUST.cust_no IN ( listed 20 more cust no's ) OR CUST.cust_no IN ( listed 20 more cust no's ) etc... This worked, but took way too long. I'll get down to trying what you said. This will take a while.
Thanks
Mike
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