Lynn Pettis (8/18/2009)

---

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now and...

GSquared (8/18/2009)

---

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now and I...

Michael Valentine Jones (8/18/2009)

---

Oracle bought Digital’s Rdb database that runs on the VMS platform to eliminate the competition. They couldn’t compete in the VMS world, because Digital included an...

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now and I fear that...

This is all explained in the article,...

WayneS: I've been trying to improve on this but it's going to take a while. It's a tough problem to improve on where it is, plus I've been pretty...

Well it tested out fine on my own data that I listed above. If you want me to test it any further I will need the DDL's and Sample...

Hmm, something very Zen about this. 🙂

jeff (8/17/2009)

---

I am trying to be very conscious of the fact that people who are donating their time to the forums would prefer to answer simple questions rather than lengthy...

Heh, glad we could help, Garadin! 🙂

Yes, that's similar to what I saw.

Try it like this instead (untested, I have to run out to a customer site ...):

drop VIEW OrgLevels

go

CREATE VIEW OrgLevels AS

WITH cteRecur AS (

SELECT r.OrgUnitID, o.Parent, 1 as Lvl,...

OH, I see, RSUNew only contains the root notes. That's the problem...

What nodes are being returned?

Thanks Wayne, Jeff.

I played around with it a little using what I felt was more naturally distributed data (making some schools much more popular than others) and it seems that...