Re: Nested Coalescing possible in SQL?
From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: 4 Jun 2004 11:56:13 -0700
Message-ID: <6dae7e65.0406041056.36952f40_at_posting.google.com>
> lennart_at_kommunicera.umea.se (Lennart Jonsson) wrote in message news:<6dae7e65.0406022337.338870_at_posting.google.com>...
> > jlanfield2003_at_yahoo.com (Jeff Lanfield) wrote in message news:<235c483f.0406021038.13a1b83b_at_posting.google.com>...
>
> [...]
>
> Hmmm, I must have been just a little bit tired there ;-) Should read
> (diff in snd part of union):
>
)
Date: 4 Jun 2004 11:56:13 -0700
Message-ID: <6dae7e65.0406041056.36952f40_at_posting.google.com>
lennart_at_kommunicera.umea.se (Lennart Jonsson) wrote in message news:<6dae7e65.0406031939.1ed5fa49_at_posting.google.com>...
> lennart_at_kommunicera.umea.se (Lennart Jonsson) wrote in message news:<6dae7e65.0406022337.338870_at_posting.google.com>...
> > jlanfield2003_at_yahoo.com (Jeff Lanfield) wrote in message news:<235c483f.0406021038.13a1b83b_at_posting.google.com>...
>
> [...]
>
> Hmmm, I must have been just a little bit tired there ;-) Should read
> (diff in snd part of union):
>
and as you probably discovered already, it can be further simplified as
[...]
union all
select
d.nodeid, d.nodeid,
(select count(1) from ancestor where nodeid = d.nodeid) as
depth
from data d
where d.color is not null
)
[...]
/L Received on Fri Jun 04 2004 - 20:56:13 CEST