The HierarchyID Datatype in SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by J P R » The HierarchyID Datatype in SQL Server 2008

16 posts, Page 2 of 2

««1 2

The HierarchyID Datatype in SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

clementhuge

Posted Wednesday, November 19, 2008 5:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 3:27 PM
Points: 89, Visits: 285

Good article. I just switched to SQL server 2008 and I played a little with all those hierarchy functions.
There is a typo though. The function is not IsDescendant but IsDescendantOf.
Other than that. Great Article.

Clement

Post #605065

jake.hulse

Posted Saturday, August 01, 2009 11:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 2:28 PM
Points: 1, Visits: 9

Your example shows

SELECT *
From dbo.Organization
WHERE @BossNode.IsDescendant(EmployeeID)

How is this rewriten using IsDescendantOf?

Thanks for the article, very interesting!
Jake

Found the answer in case any other newbs stumble across this:

DECLARE @c AS HierarchyID
SELECT *
From dbo.Organization
WHERE @c.IsDescendantOf(Organization.EmployeeID)

Post #763630

Fozzie

Posted Monday, August 03, 2009 9:02 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 356, Visits: 754

And Reparent is now GetReparentedValue...

Good article, I am wandering myself about using this rather than the old child / parent id of past. One of the issues where I work, is getting everyone on the same page.

P.S I know this was written a year ago.... how things change! Tongue

Post #764124

JRoughgarden

Posted Thursday, December 10, 2009 6:17 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 6:07 PM
Points: 36, Visits: 167

Great article. I apologize for my rude English-speaking compatriots. You seem to speak French natively, and I very much appreciate your writing the article in English, because I sure don't speak French. Incidentally, I had little trouble understanding your article, but it would be a good idea to get an English editor in the future. You could even contact me!

Post #832660

Venky Subramaniam

Posted Sunday, October 24, 2010 2:14 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, March 29, 2013 4:22 PM
Points: 25, Visits: 94

[font="Tahoma"][/font]
Extremely well-written article with lots of valuable input but as some of the readers have observed (rather correctly), it would have been greatly helpful if the French was somehow substituted with English (the World's accepted dictum) that would make the author's sincere efforts fully appreciated and assimilated as should be...

I wish I knew French and that would have certainly made it easier to think like the author....If wishes were horses...:)

Post #1009732

David McKinney

Posted Friday, November 12, 2010 1:10 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582, Visits: 1,601

Excellent article...pitched just right for me. Like some of the other readers, I found that it required a little effort to understand, but that was to do with the subject matter rather than the style / language.

To go from Recursive CTE to HierarchyId, was a lot to chew, but it tasted great.

I'm sure I'm not alone in saying that I'm quite shocked by the tone of some of the earlier comments, and I hope it won't dissuade you from writing more articles.

Thanks,

David McKinney.

Post #1019751

« Prev Topic | Next Topic »

16 posts, Page 2 of 2

««1 2

Permissions