Mark,

That looks to be very much what i need.  I am currently in the process of trying to understand the differences.

Thank you so much for your...

To help illustrate my issue.....

So here is an example data set:
create table #TEMP 
(ID varchar(10),
Parent Varchar(10)
)

Insert into #TEMP
values('1A',NULL),
('2A','1A'),
('3B','1A'),

Hi,

Just to clarify.   For this odd example I want the nodes shown more than once.  So the top most node will show every node.  The second layer will...

Hi,
Thanks for your reply.

Sorry if i am not being clear.  I need to get all the descendants and not just the children.  So i need the children's...

Hi Joe,

Thanks for the message. I am trying it now.  Not sure if this is going to be too much (in terms of data - and performance).

Thanks for everyones help.

I worked out a quick way to do it.

So effectively i numbered the columns 1-5 the opposite way round. Then in unpivoted the data making one...

Luis Cazares (9/25/2015)

---

danielfountain (9/25/2015)

---

However i do think this would work.... VERY slowly though. I keep feeling there is something...

Luis Cazares (9/25/2015)

---

I'm not sure if this is a good idea:

WITH rCTE AS(

SELECT s.saleid, u.userid, b.businessunitid, b.name, b.parentbusinessunitid, 1 AS n

from...

Sean Lange (9/25/2015)

---

danielfountain (9/25/2015)

---

Hi all,

I have been away from SQL for a couple of months, and for the life of me cannot work out a simple way to do what...

Cadavre,

Thats the ticket. I must say i have never used cross apply and i might need to do some research. I dont understand how that part works...

Sorry i dont think i have explained myself well.

There are 5 separate columns all with dates in...

Thank you for the question.

I always find the questions that i straight away feel i know the answer a little disconcerting. I always feel i have missed something 🙂

Koen Verbeeck (6/23/2014)

---

Maybe the editorial process could include something like "copy paste a sentence into google and see if something turns up".

It will not catch everything, but at least the...

Koen Verbeeck (6/18/2014)

---

BWFC (6/18/2014)

---

Koen Verbeeck (6/18/2014)

---

BWFC (6/18/2014)

---

This explicitly rules out that the databases are...