Interesting. Under most circumstances, the two are semantically and functionally equivalent. But in this case, it can't parse the query correctly. I get a "Can't bind M.superiour"...

On hierarchies, While and rCTE usually do one index scan per level in the hierarchy. It can blow up to one scan per node in some cases. That's...

Awesome find. Sounds perfect for what you need.

GNU does some seriously good work. I've used a bunch of the products from that community. GNUPG for example.

Nope. You'd have to at least add the plan to the query. And even that's not guaranteed to work.

Yeah. You found the same thing with the documentation that I did. It seems to contradict itself.

Jeff Moden (9/10/2012)

---

There are some people who insist on building the Nested Sets data in a single query. I don’t know why, since this does it accurately and in...

RBarryYoung (9/13/2012)

---

GSquared (9/13/2012)

---

RBarryYoung (9/12/2012)

---

GSquared (9/12/2012)

---

RBarryYoung (9/12/2012)

---

...

Well, I may have over-reacted. I am trying to an IRS download directory (http://www.irs.gov/pub/irs-soi) but a I cannot get a connection. I don't...

While an rCTE vs a While Loop can be a poor decision, there are other times when it's not.

Tests that don't involve any table-query, just Insert statements, or a RAM-resident...

I just played around with this a bit.

Per MSDN (http://msdn.microsoft.com/en-us/library/ms189491.aspx):

It looks like the language setting...

Where I've run into that kind of thing, I usually have the script/proc insert the rows I want to work on into a temp table, then run the string manipulation...

RBarryYoung (9/12/2012)

---

GSquared (9/12/2012)

---

RBarryYoung (9/12/2012)

---

...

Well, I may have over-reacted. I am trying to an IRS download directory (http://www.irs.gov/pub/irs-soi) but a I cannot get a connection. I don't think it...

Eugene Elutin (9/12/2012)

---

...

The only way to make it more efficient is to shortcut the math. That's why some are hard-coding 3 as the final digit. (It only saves...

RBarryYoung (9/12/2012)

---

GSquared (9/12/2012)

---

RBarryYoung (9/11/2012)

---

GSquared (9/11/2012)

---

SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will...

Murphy hates us. 🙂

You're welcome.

Eugene Elutin (9/12/2012)

---

I've tried all three methods, INNER JOINs, CROSS APPLY and CROSS JOIN with WHERE: all produce very similar query plans with use of Nested Loops (Inner Join).

Cannot...