Information générale
Forum:
Microsoft SQL Server
>>>>>Kevin,
>>>>>
>>>>>> the SQL consists of 1000's of UNION selects
>>>>>
>>>>>You need a serious redesign of that query!
>>>>
>>>>Unfortunately it's a generated query, typically when we perform searches against the database we just return the primary key's to save time, then if necessary the records are fetched in whole.
>>>>
>>>It still doesn't explain why you need 1000's UNIONs. :)
>>
>>I could use IS, but apparently that has its own problems, are there any other options?
>
>It's hard to answer your question w/o knowing what you're doing. :)
Array of primary keys needs to return array of BusinessObject, so rather than fire off say, a 1000 individual SELECTs I want to execute the entire query in one swoop to improve performance.
Kev
Précédent
Suivant
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