Re: Help writing SQL query

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 07 Dec 2004 21:54:36 -0800
Message-ID: <1102485170.39596@yasure>

Tony Andrews wrote:

> ana wrote:
>

>>"Barry Bulsara" <bbulsara23_at_hotmail.com> wrote in message
>>news:1102452429.26479.0_at_damia.uk.clara.net...
>>
>>>>BTW: Why can't the design be fixed? You have to realize that this

>
> is
>

>>>>going to bite you on the posterior every single time you try to

>
> use it.
>

>>>The purpose of the SQL query I want is to fix the design.
>>
>>When your only tool is a hammer, all problems are treated as nails.
>>A hammer is not an effective board cutter (a saw) regardless of how

>
> hard you
>

>>swing it.
>>Folks have been trying to give you a clue that you have selected the

>
> wrong
>

>>tool.
>>So, You're On Your OWN (YOYO)!

>
>
> What, you mean SQL is the wrong tool? Or what?
>
> It seems clear to me that Barry is faced with a crap database design
> from which he needs to extract the data - whether to re-insert it in a
> better design or not is irrelevant really. Saying he should instead
> try extracting the data from a better designed database is bizarre
> frankly!

That is not what anyone has said to him. He posted a red herring ... not the actual design he is working with. He is apparently trying to move the data to a "better" design but hasn't shared that either.

Quite frankly he is his own worst enemy at the moment. That's what we are trying to tell him though no one so far has gotten that message across successfully.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Dec 07 2004 - 23:54:36 CST