Workaround for 'Maximum number of user tables under all sides of a UNION statement...'

I'm creating a query with 46 UNION ALL statements. I'm getting the
following error message:

Maximum number of user tables under all sides of a UNION statement can
not exceed 256 Please simplify the query and retry.

The explanation follows:
Explanation:
Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.

I can't simplify the SQL anymore than it already is. Any suggestions
for a work-around?

.

Relevant Pages

  • Re: Workaround for Maximum number of user tables under all sides of a UNION statement...
    ... not exceed 256 Please simplify the query and retry. ... command to conform to the requirement specified in the error message. ... I can't simplify the SQL anymore than it already is. ...
    (comp.databases.sybase)
  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: Background Web Queries flaws!
    ... There is no way to trap errors on a background query. ... There is no way to control the timeout setting. ... The basic problem is that IE spits an error message before returning control ... > hard coded a 5 minute limit into the web query system. ...
    (microsoft.public.excel.programming)
  • Re: Update Query only works first time
    ... I don't know either -- but that is what you error message says -- perhaps you are not using an updateable recordset or records were locked by something else like a form or query ... Microsoft Access MVP 2006 ... It works the first time, but then there is a very long error message with several reasons why it does not work. ...
    (microsoft.public.access.queries)
  • Re: SQL Compact Edition does not recognize parameter
    ... you might try looking in the debugger to see what the parameters collection looks like before you execute the query. ... assured that all computers have the same installation. ... It's always the same error message althought there are 35 parameters ... Only the hardware is different but on one PDA the problem exists ...
    (microsoft.public.sqlserver.ce)