I\'m working on a project that required categories, I used a neste开发者_高级运维d set model and it worked out well.I have another portion of the same project, however it requires a different type of
I am trying to develop a catalog project in ASP.NET MVC 3 and using EF Code first with an existing Database. There is a Categories table in m开发者_Go百科y database that points to itself. For that, I
I\'m trying to get the first category (level zero, no parents) from a child category (which might be any level) with just one query with MySQL. Is that possible?
In another question I asked about visualizing hierarchical data stored in a table in an SQL Server database. I found a way to visualize the whole hierarchy using GraphViz, with some plumbing in T-SQL
I have a simple sqlite3 table that looks like this: Table: Part PartSuperPart wk0Zwk00 wk06wk02 wk07wk02 eZ01eZ00
Anyone, please help me with the SQL query for traversing the tree. I have a ta开发者_JAVA百科ble called users, which has the columns id, name , and parent.
I am working in SQL Server 2008 R2 with a priority ordered set of content that must be assigned to a set of buckets to achieve a content specified value.Each item in the content list is related to nod
I\'m trying to write a recursive query in SQL Server that basically lists a parent-child hierarchy from a given parent. A parent can have multiple children and a child can belong to multiple parents s
I have a parent row and child rows on 7-10 separate tables, with a unique key tying the rows on the child tables to the parent row.For a search feature,I need to retrieve the parent and all the matchi
I have the follow table: example: nodes: id_nodeid_parent -------------------- 13 32 2-1 I want to insert in other table the level of descent. For example: