I think that what you really want is a recursive View, like this:

CREATE VIEW OrgLevels AS

WITH cteRecur AS (

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

FROM RSUNew r

LEFT JOIN ISC_OrgUnits o ON...

ramsp (8/12/2009)

---

How can we read the following structure in SQL 2005?

...

Actually, sending to DBMail should be OK within a trigger. Unlike SQL Mail. DBMail is mediated through Service Broker under the hood, so those Email problems like network delays,...

..+ hunter +.. (8/12/2009)

---

Hi Lowell

Thanks for a quick response, Actually my main goal here is I have two database in where it can be place in the same server (what...

Try executing this command yourself manually from within SQL Server and see what you get:

EXEC master..xp_cmdshell 'getfiles.bat'

Very cool, Rudy!

Yes, definitely.

my real example includes more : a booking...

Nice article. I have a couple of notes though:

1) What you are describing is actually a simplified informal version of EBNF, not BNF (though the standards groups do...

Jeff Moden (8/11/2009)

---

Phil had mentioned something about the documentation in my code... It's nothing compared to the absolutely incredible documentation that some others included in their code. For example,...

Nah, that's me. Jeff hates the term "pseudo-cursor" and much prefer's Phil's...

🙁 Wow, do I get that a lot. I have found that people find me much less...

True, and thanks again to you Peter for pointing out the bugs in my original solution so that I...

Paul White (8/10/2009)

---

Jeff Moden (8/10/2009)

---

In Lowell's example, it also turned a 13 byte string into a 20 byte Varbinary so it's expensive, too. But, I believe that Barry's point...

Paul White (8/10/2009)

---

Hey Barry,

On the other hand, it is relatively slow, only works on strings, and returns varbinary(8000).

If the task is to detect...

:w00t: Woo-hoo! Finally, my name in lights!

Thanks, Phil and Joe. You too Jeff. 🙂

Fast though it was, my submission was far from elegant or simple....