Good night all from tomorrow on I will prbably banned from this NG...But that's not important...

And READ READ READ ....and do not fall in fallacies!!!

Regards all,

Check out DATE's principle of incoherence...

*It is difficult to treat in a coherent manner what is inherently incoherent*

//I'll leave this thread with this: Cimode, if you had come to the discussion and simply said "I disagree with X, Y, and Z that you wrote; and this is...

Link onto DATE and DARWEN's work on systematic ways for the treatment of missing data...What Mike C mistakes for using NULLS

http://www.dcs.warwick.ac.uk/~hugh/TTM/Missing-info-without-nulls.pdf

Gosh only an ignorant could mistake a Systematic Treatment of Missing Data for using NULLS in the firs place...NULLS are the WORST possible way to handle missing data and it...

//Rule 3: Systematic Treatment of Null Values

A field should be allowed to remain empty. This involves the support of a null value, which is distinct from an empty string or...

//If you look past the insults back and forth, this could have been a really good discussion. I thank Cimode for offering his ideas but wish it could have...

//You are quite a piece of work, and I think I'm pretty much through debating anything more with you, as you're completely illogical in your arguments, your code is horrible...

What Mike C can't make in reasonning he tries to establish by pointing out simple copy and paste errors...He does as if he does not understand what is my intent...

I do not do personal attacks but I don't mind pointing out absurdities.

Who else than an ignorant would write such absurdities?...

You are delluding [sic] yourself. You have not responded to...

Ladies and gentlemen...

I have received the following letter from the Moderator Steve Jones...

It should be censored in the next few minutes but it is an intimidation attempt...I let people judge...

Scenario #1. Say, we need to create a database of people working in an organization. People come and go, they've got hired and leave. We need hire date and termination...

//Not sure why they decided it should be that way, and it does seem rather arbitrary from my perspective, but it's what they voted on and accepted... On the...

//Thanks Mike. I've read the article, but still don't understand the rationale behind ANSI SQL mandating SUM to ignore NULLs. (A good thing I learnt though is that as another...

As you stated:

So far I have produced:

--> Code examples to establish the dangers of NULLS

Your code examples are buggy and do not run.

Copy and paste pbs... Corrected

[Snipped diversion to primary...