Viewing 3 posts - 1 through 3 (of 3 total)
Thanks,
My problem is a bit more complex, I thought about this concatenation-solution but actually this colB is not one column but several columns. I could still concatenate the values into...
June 17, 2014 at 1:49 am
#1722166
Hi, Cool stuff this CTE, but I have a question about the example.
Suppose I want to return not only the leaf-to-parent relation, but also any subparent-to-parent? For example, b ->...
January 31, 2011 at 2:34 am
#1280290
Thanks. One comment:
while (@intCounter <= @intMaxId) should be
while (@intCounter < @intMaxId).
July 28, 2010 at 12:49 am
#1199084