Thank you.

That does it. Knew it, I was over thinking it.

Reading further into resolving this on my own. I may have to Unpivot first before Pivoting it. Am I on a right track here?

Thanks Dave. I shall look into it.

Jeff Moden (4/22/2012)

---

WRACK (4/22/2012)

---

Jeff Moden (4/22/2012)

---

Let it be known right up front that I don't use the HierarchyID datatype because I prefer other methods. That, notwithstanding, the way to...

Jeff Moden (4/22/2012)

---

Let it be known right up front that I don't use the HierarchyID datatype because I prefer other methods. That, notwithstanding, the way to do the sort...

Dave Brooking (4/22/2012)

---

I think the solution is not with the select but with your stored procedure usp_AddEmp. You need to insert the child with the appropriate HierarchyId. Possibly something like

--...

No takers?

No I haven't but I was hoping to avoid that as using HIERARCHYID gives me a direct view of the tree without using CTEs due to the topological sorting key...

Thanks Kevin. I shall run and find out if we can improve using the better disk strategy.

Did not realise that this topic was still going. Well I have something to report. The client has finally appointed a DBA and I shall gladly handover everything I did...

Perry Whittle (2/20/2012)

---

Completely understand, but in my experience pointing out their flawed maint plan and correcting it should serve to gain you a little kudos and maybe even an extension...

Perry Whittle (2/20/2012)Forgive me for laughing and I don't mean to be rude but!

You're saying you don't have an hour or so of your time to go find a decent...

GilaMonster (2/20/2012)

---

So large amount of CPU and time shrinking the data file and fragmenting the indexes followed by another large amount of CPU and time spend rebuilding those indexes and...

GilaMonster (2/20/2012)

---

I would strongly suggest that you consider removing that shrink from the maint plan. There's just about no good reason to have one running on a regular basis.

Also, you...

TheSQLGuru (2/20/2012)

---

Perry Whittle (2/20/2012)

---

Agreed, that and removing wacko maintenance...