Re: 3vl 2vl and NULL
From: David Cressey <david.cressey_at_earthlink.net>
Date: Tue, 06 Dec 2005 14:23:55 GMT
Message-ID: <%9hlf.79$Dd2.36_at_newsread3.news.atl.earthlink.net>
Date: Tue, 06 Dec 2005 14:23:55 GMT
Message-ID: <%9hlf.79$Dd2.36_at_newsread3.news.atl.earthlink.net>
"dawn" <dawnwolthuis_at_gmail.com> wrote in message
news:1133834551.860204.241810_at_g44g2000cwa.googlegroups.com...
> You know, Jonathan, those U2 folks work for the same company as you --
> you could check with them how they handle a 2VL as I'm sure they know
> better than I how it is implemented. I only know that it works fine
> until I have to figure out how to combine SQL with it. The best I've
> done is pass nulls in numeric fields to SQL as if they were zero,
> which, of course, skews averages quite badly.
Don't pass them. Filter them out. Received on Tue Dec 06 2005 - 15:23:55 CET