Maybe, but short integers are a heck of a lot easier to read the GUIDs.

Alvin Ramard (8/12/2009)

---

Should I pass on this link?

Take a look at the rest of his posts. He's looking for quick answers...

kgoyena (8/12/2009)

---

WITH DirectReports(parentNode, childNode, LEVEL ) AS

(

SELECT e.parentTocNodeGuid, e.tocNodeGuid, 0 AS LEVEL

FROM TocNodes AS e

WHERE ...

Gail, here's one for you😉

kgoyena (8/12/2009)

---

I looked at the sample code in BOL and the query runs but is not returning the records in the sequence I want. It returns the first level...

Steve Jones - Editor (8/12/2009)

---

Nope, nor does...

Steve Jones - Editor (8/12/2009)

---

Barry,

That's actually a pretty good suggestion, though I'm not sure how easy that is to set up. I'll have to see if we can creatively try...

I'm going to go out on limb here, but the problem isn't your query. It is the amount of data you are trying to pull down to you desktop...

Look at the sample code in BOL under Recursive CTE's. You can access BOL from SSMS by pressing the {f1} function key.

You can also check out this post as...

How big is each row (in bytes)? What type of network are you on 10MB/100MB/1000MB? Are connected to the network via a switch or hub?

mish (8/12/2009)

---

I have done the questions and it was just question 4 I had problems with. I have just been told that SQL server does not have the LIMIT so...

john.arnott (8/12/2009)

---

And laugh even harder again at the response to...

Laugh I did at the image of Qui-gon and Yoda, both with light-sabres ready, asking Is this homework?

Tim Walker (8/12/2009)

---

Steve Jones - Editor (8/12/2009)

---

The disclaimer is another idea that we can look at. I'm not sure quite how to word it, and my guess is that we'll...

Think I do that school work this is, right?