|
|
Posted by Hugo Kornelis on 09/30/05 22:57
On 30 Sep 2005 04:11:34 -0700, Zero.NULL wrote:
>My multiple level nested corelated query is not fetching correct
>result. It work fine on small set of data, but fails on larger set of
>data. Any clue?
>
>Explaining data storing and discussing design would be tough for me
>here, still to show you how complex I have created my life, here is the
>query:
(snip)
Hi Zero.NULL,
Wow! I mean, like, WOW!!!!
Sheesh, you sure know how to make simple things complicated.
After staring in amazement at this code -no, make that: this disaster
waiting to happen- for a while, I can only conclude that I'm very sure
that it's possible to simplify this code considerably. But not without
knowing more. At the very least, please post the table structure of all
tables included in the query, posted as CREATE TABLE statements. You can
omit columns that are irrelevant for the query, but do include all
constraints (esp. primary keys, unique, nullability, and foreign keys
are very important).
If possible, include some rows of sample data (as INSERT statements) to
help clarify what the query is supposed to do, and/or a briefe
explanation of the business problem you're trying to solve.
Check out www.aspfaq.com/5006 for more details on the best ways to aks
for help in these groups.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|