I have just started working with hierarchyId in Sql Server. I am looking at different functionalities in SQL server. However, this sounds to me like a call to very thick data layer, which I want to ...

We commonly get asked to include certain levels of a hierarchy in a report and I am looking for a way to speed up the query performance with hierarchyid. I did some testing and and I have queries that ...

I realize that I can convert a hierarchyid to a string variable, and store it as a string in an SSIS memory variable. what I can't figure out is a bulk insert within SSIS, and use the memory variable ...

Problem: I need to extrapolate the parentID from the hierarchyID.
Example: My columnID is 8 and my current hierarchyID is /1/2/4/8. When I call columnName.GetAncestor(1), this will give me /1/2/4/. ...

I'm trying to use the EntityFramework.HierarchyId Nuget Package to add support for the HierarchyId datatype inside of EF 6, the problem is that everytime that I add the package and try to build the ...

I currently have an issue with a query that is running slow and need some advice on how to speed it up. We're currently in the development stage and I've been given a lot of development time on this ...

We have a database that models a tree. This data can grow fairly huge, that is to say many, may million of rows. (The primary key is actually a bigint, so I guess potentially we would like to support ...

I have a set of hierarchical data being used in a SQL Server database. The data is stored with a guid as the primary key, and a parentGuid as a foreign key pointing to the objects immediate parent. I ...

What is the best possible way to show the data in hierarchical display, i have used HIERARCHYID in sql but i am not able to get the data properly when it's level exceeds to more than 10 (horizontal ...

I have a hierarchical data. The most common queries will be "get parent branch for node" and "get subtree of node". Updates and inserts are not likely to occur often. I am choosing between nested sets ...

Specifically we have a SQL Server stored procedure that accepts a hierarchyId as a parameter, and typically we have a SOAP layer on our stored procs that allows them to be called via SOAP.
The SOAP ...

I have a dataset containing (among others) the values hierarchyids and the Parent-hierarchyids.
For another query I need the lowest common ancestor of the hierarchyids and since I am fairly new to sql ...

I have two tables, one table is the items container, which holds all data related to the products. The other table is for categories, in which the data is organised using hierarchies.
The goal of the ...