Re: log/log10 functions truncate my resultset
- From: Dimitri Furman <dfurman@xxxxxxxxxxx>
- Date: Sat, 25 Feb 2006 01:23:26 -0000
On Feb 24 2006, 06:09 pm, Erland Sommarskog <esquel@xxxxxxxxxxxxx> wrote in
news:Xns9775190B2482Yazorman@xxxxxxxxx:
BernsteinVsTheDb (Orr.Bernstein@xxxxxxxxx) writes:
Hello all,
I have a table that contains 100+ rows. I'm trying to run a query that
looks like this:
SELECT ..., log10(...) as Rank FROM Table
and the resultset contains only the first row of results.
SELECT ..., log10(...) as Rank FROM Table ORDER BY Rank
returns no results at all!
If you replace log10 with log, it does the same thing. However, if you
replace log10 with abs, it returns exactly what you'd expect, all 100+
rows.
Are all the numbers you perform log/log10 on > 0?
Funny thing is, I had this exact issue today while ranking results.
Log10(0) produces a "A domain error occured" warning message in QA and
causes an empty result set to be returned.
--
remove a 9 to reply by email
.
- References:
- log/log10 functions truncate my resultset
- From: BernsteinVsTheDb
- Re: log/log10 functions truncate my resultset
- From: Erland Sommarskog
- log/log10 functions truncate my resultset
- Prev by Date: Question about Joining 2 tables??
- Next by Date: Detroit SQL Server User Group.
- Previous by thread: Re: log/log10 functions truncate my resultset
- Next by thread: <ANNOUNCE>Building XML Workflow Applications
- Index(es):
Relevant Pages
|
|
