John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
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....
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement