Yes Jeff that worked a treat,...

====== http://www.clothes8.org ======

Air jordan(1-24)shoes $30

Handbags(Coach l v f e n d i d&g) $35

Tshirts (Polo ,ed hardy,lacoste) $15

Jean(True Religion,ed hardy,coogi) $30

Sunglasses(Oakey,coach,gucci,A r m a i n i) $15

New era cap...

Jeff where to start, this code seems to work perfectly, just had to change it to work for 10 levels 🙂

So 2 things:

A) Thank-you so much for helping me on...

Typical its been blue sky all week!!

Although I am right on the English border (NW Wales) so quite a distance from there!

Shell Island, spent many a good weekend there sure you'll have a great time 😀

Get the beers in and the BBQ out 😉

Ahh coming to my neck of the woods are you! 😉

Where you going Anthony?

Jeff thank-you! 🙂

I'll run it on my test box and let you know how I get on in a bit 😀

If this works I'll mail you a crate of your...

SQL Padawan (7/24/2012)

---

I really am having fun with hierarchyids but here is a solution assuming there are only 5 levels. 😛

I had to tweak the code I wrote earlier.

DECLARE @TEMP...

Yes I think your right, I'm still trying to get my head around this as have never had to deal with this kind of data..

Consider my posted result for Parent...

Hi Jeff

Thanks for...

Hi

Apologies I've had my head down trying to get this solution put into place

There are some interesting approaches on this thread and I would like to ask for your help...

No problem at all Jeff! 🙂

Yes as you suggest...

Jeff Moden P.S. A While Loop will actually beat the rCTE for performance here. It's not substantial enough to necessarily warrent its use but I thought I'd bring it...

@Andy,

If you're sure there are no "loops" within the hierarchy, you could set the MAX Recursion Limit to "0" to be unlimited. I am, however, concerned that you may actually...

If you want to get away from recursive hierarchy crawling, you have to go with either a nested sets hierarchy, or use the SQL 2008 (or later) HierarchyID datatype, or...