Hi Sergey,
That was not for a specific SQL statement I have developed a query and report
and engine and trying to solve problems in general. Also you can check this
link to see how that query engine works:
http://www.dfarber.com/query_engine.htmBut if you have some ideas for SQL statement improvement please let me look at
that. In some cases instead of using long tables names it is possible to have
an alias with short name, but that’s may not be enough in some cases when there
are some expression against each field like IIF() and more.
Regrads,
Doron
>>Hi Sergey,
>>
>>The difference is that each cursor came from a different table, you referred
>>in each Select into the same table which was Table1. That was not my
>>case. Maybe when you meant Table1 in the second SQL and it was a typo,
>>I was not sure. That was enough for me to get the idea.
>
>Yes, it was typo, sorry.
>>
>>The idea behind all of that manipulation is to find a way to bypass the 8192 characters max problem for each Select statement, by breaking 1 big SQL into small SQLs and re-merge them.
>>
>
>Can you show your actual "big" sql select? Maybe we can make it "fit" into 8192 characters.
>
>< snip >