John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
Microsoft SQL Server
>Can you please be more detailed on the relationship within the table. This type of ordering is usually easily accomplished with a simple group and partition by but the details are not jumping out at us. It almost seems like there is a missing key for the relationship unless your results are just varying all over.
Hi Ted,
this is a self-referencing hierarchy. Each child points to its parent. If the key is null it is the top level parent. So in the example, "Add Category Library" is the top level parent. The "add category", "add category language", etc. are 2nd level parents as are the corresponding "delete...". The edits are children of the 2nd level items and so on....
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only