Posted by Hugo Kornelis on 08/17/05 23:46

On Wed, 17 Aug 2005 08:07:30 -0500,  wrote:

>| If you have business reasons (as is often the case) for needing to keep
>| details of your schema secret, break the DDL down to the bare minimum that
>| accurate describes the problm you're trying to solve.
>
>jesus christ! how much more "bare minimum" does this get:
>
>"all tables have a varchar(50) column called uniqueId. the lineitem and
>auxiliary tables have an additional varchar(50) column called
>parentUniqueId...i'm trying to get only those related items where neither
>poId, lineId, nor auxId are in a list of supplied values."
>
>there is *no* guessing involved. not only have i provided the structure for
>each table, their relation to eachother, a sample of what their data looks
>like, but i've even written 90% of the goddamn query...i need help with the
>criterion! can no one do that?!!
>

Hi ,

As Erland already pointed out in his first reply:

"what we are very fond of are:

o CREATE TABLE scripts for the involved tables (preferrably simplified
to cover the essential in the problem)
o Sample statements with INSERT data.
o The desired result given that sample.

There are at least two reasons we like this:

1) By copying-and-pasting the scripts into Query Analyzer, it's easy to
develop a tested solution.
2) It helps to clarify ambiguities in your narrative."

I fully agree with Erland - if you post the requested information, in
the requested form, then I'm quite sure that people can help you. But if
you decline to provide the information in the recommended form, then you
are indeed making it impossible for us to help you.

Some tips for assembling the CREATE TABLE and INSERT statements we need
to help you can be found here: www.aspfaq.com/5006.

And one other suggestion - don't use swear words. Some people are
offended by language like that. And if you are seeking help, offending
those who offer to help for free is generally not a good idea.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]