Top "Hierarchyid" questions

hierarchyid is a TSQL extension available from SQL Server 2008 to map hierarchical structures in a flat table.

How do you get all ancestors of a node using SQL Server 2008 hierarchyid?

Given a table with a hierarchyid type column, how do you write a query to return all rows that are …

sql-server hierarchyid
HierarchyID: Get all descendants for a list of parents

I have a list of parent ids like this 100, 110, 120, 130 which is dynamic and can change. I want to get all …

sql-server tsql hierarchyid
How to find ALL descendants using HierarchyID for SQL Server

I need to find all descendants of a category using HierarchyID for SQL Server. I know how to find direct …

sql sql-server-2008 tsql hierarchyid
SQL 2008 HierarchyID with Multiple Root Nodes

I wanted to use the new HierarchyID type in SQL Server 2008 to handle the page relations in a small wiki …

sql-server hierarchyid
HierarchyID in Entity Framework not working

We are using WCF Data Service based on an Entity Framework model for our application. In this we need to …

c# entity-framework hierarchyid
HierarchyID How to get all Parent from a child

i've a Problem with the hierarchyID and UserRights for a Menu. I only want to give the User the Right …

hierarchyid
Generating HierarchyID

I would like to insert the hierarchyId like this / - CEO (Root) /1/ - Purchase Manager /1/1/ - Purchase Executive /2/ - Sales …

sql sql-server-2008 hierarchical hierarchyid