General information
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 IN, but apparently that has its own problems, are there any other options?
>
>Kev
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