Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

The HierarchyID Datatype in SQL Server 2008 Expand / Collapse
Author
Message
Posted Wednesday, November 19, 2008 5:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 28, 2014 4:03 AM
Points: 89, Visits: 293
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
Posted Saturday, August 01, 2009 11:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 1:49 PM
Points: 1, Visits: 12
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
Posted Monday, August 03, 2009 9:02 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:27 AM
Points: 359, Visits: 890
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!
Post #764124
Posted Thursday, December 10, 2009 6:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:06 PM
Points: 37, Visits: 176
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
Posted Sunday, October 24, 2010 2:14 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 4:11 PM
Points: 25, Visits: 105
[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
Posted Friday, November 12, 2010 1:10 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:56 AM
Points: 641, Visits: 1,794
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 »

Add to briefcase ««12

Permissions Expand / Collapse