Re:"Long query" problem
Have you thought of simplifying your queries by views. If the where clause
can be determined at run time, it can be moved to the view, or perhaps the
tables in the joins. You can use shorter alias for the columns to squeeze
some space out. Of course, it would be perfect if you can save the whole
unioned query into a view.
HTH,
Ping
Quote
Ante epi? <in...@st.tel.hr> wrote in message
news:01bff704$93aecea0$0201c6c6@soft...
Quote
> Hi, I'm working with MS SQL 6.5 server. When I try to execute long query
> (in fact 24 querys in union) I receive an error "Memory request for 2078
> bytes exceeds the size of single page of 2044 bytes". If I remove one of
> "selects" in the whole query or remove some table from relations in the
> "WHERE" clause it works.
> What can be done?
> Thanks!
