Re: All hail Bob (not)!

Gene Wirchenko wrote:
On Mon, 08 May 2006 08:02:42 GMT, Frank Hamersley
Bob Badour wrote:
jiiiiim@xxxxxxxxxxx wrote:
Frank Hamersley wrote:
Bob Badour wrote:
[..]

I agree it is no problem to write the query to get the average ages
where the age is known. Using null, how does one write the query to
get the correct result, ie. the average is unknown ?
select case when count(*) = count(age)
then avg(age)
else null
end as avgage
from table
What say you Bob? The silence to date has been most instructive.

Cheers, Frank.
Apparently, you do not know the meaning of plonk. I see you use two
email addresses. Plonk again.
You *are* simply a dullard of the first order - of course I used a second email address given you had dumped the first in your killfile. My standards of etiquette required bringing the above post to your attention before handing you "the white feather" for having deserted the original thread line prior to conclusion!

If you think it is appropriate to require the godawful mess above from a casual user to get a correct result for a simple query, you only confirm that you are an embecile.
Feasibility was simply the challenge you posed - your subsequent protestations surely and simply demean yourself!

All this confirms my view that whilst you have significant knowledge in the CDT domain (and certainly more than I would ascribe to myself), you don't have the guts to stick out a discourse that does not go entirely your own way. Of course this is normal for bullies when events take an unexpected turn.

Much more curiously though your resort to bombastic posts (whilst a feeble trait IMO for anyone professing intellectual tendencies) seems to have recent CDTzens in thrall given the deafening silence to date. I would have thought there would be at least one with an opinion for either of our respective stances. Ce la vie - I live and learn.

You are not doing so bad at the bombast yourself.

An interesting comment and fair; cruel, but fair like Dinsdale. Clearly I was particularly identifying Bobs legendary abruptness with people he holds have nothing to contribute. However I will not resile from a style that hopefully has some wit and is more prosaic than simple utilitarian statements where possible. Even if the subject matter is dry the discussion can have a bit of colour IMO if it doesn't unduly affect the outcome.

More flame and less smoke, please.

:-) I thought there was enough flame(ing) already and hence very little smoke.

What is it with Bob though? Its not like its a case of the Emperors New Clothes - rather its more like a second rate knot in the cravat yet no-one else seems inclined to point it out, or conversely even lambast me if my response is faulty.

Cheers, Frank.
.

Relevant Pages

  • Re: Refining query
    ... Have you ever heard the joke about Bob ... so...if I were to create a DISTINCT query of "qryBigSet" on fields ...
    (microsoft.public.access.queries)
  • RE: Summing Fields
    ... query for the order details that match the order shown on the main form. ... shown on the subform. ... "Bob Love" wrote: ... I use a query to find all details that match the order # in the main form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Manipulation of strings query
    ... > I have received the data in an excel spreadsheet which contains the ... The query then returns the names ... So modify the query so it returns the names in separate columns ... ... Bob Barrows ...
    (microsoft.public.inetserver.asp.general)
  • Re: 2nd try, left join
    ... Thank Bob. ... and it seems to loop forever and return results in the millions when the highest result doing the query on Pet column at a time is less then 15000. ... >> You're going to need to provide some sample data and desired results ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: All hail Bob (not)!
    ... how does one write the query to ... You *are* simply a dullard of the first order - of course I used a ... second email address given you had dumped the first in your killfile. ... Much more curiously though your resort to bombastic posts (whilst a ...
    (comp.databases.theory)