Beautiful, thanks so much!

Got it

Thanks!

But wouldn't it create a recursive call on that trigger? Updating the same table that the UPDATE trigger is defined on?

Thank you

"Housecleaning" in this case is in part resetting this flag to 0 everywhere... Apologize if using this word creates a confusion, I should probably call it a "checkpoint" or something....

The last one I could not get working for some reason, but i'll take another look

Thanks again

This is exactly it,

Thanks so much guys

There are no errors in SSMS

Changing WHERE from "...Field1 LIKE '%condition%'..."

to "...LEFT(Field1, 500) LIKE '%condition%'..."

seems to resolve it. WHY?))))

Thanks, but why would it matter? Again, it's when I am introducing changes to my dataset sql and then simply switching to, say, layout tab or preview or just save......

Thanks again Lowell

Thank you Lowell,

unfortunately doing it in HTML is not an option here

L' Eomot Inversé (11/14/2011)

---

Provided there is no loop in the table (ie there isn't a node which is its own ancestor) you can do it with CTEs w/o getting into...

Well... Yes and no)))

The "nodes" in my case are alpha-numerics so there is no guaranty that the minimum one would be a root parent

In your code, are you using...

Yes, it would return all nodes going from "root" (or any other given parent) down. Unfortunately, in my case I do not...

Dev (11/12/2011)

---

Just to make sure I understand it correctly...

If you have start with Node 8 as Child, it has 2 parents (6&7)

6 has 2 parents -> 2 &...