Re: implementing hierarchy

From: --CELKO-- (jcelko212_at_earthlink.net)
Date: 02/15/05 

Date: 15 Feb 2005 10:40:05 -0800

>> Then Joe C has a post where he gives a more complex version that has
some benefits, but is still quite messy, depending on your actual
needs. <<

What I find to be weird is that the kids who grew up with HTML, XML, et
al think that the nested sets model is easier that the adjacency list
model. Us old farts who used to use pointer chains and traverse links
found the adjacency list model to be the most natural.

The other advantage of the CTE is that you can avoid creating a VIEW
for a table expression that has to be used twice or more in a query.

Relevant Pages

  • Re: silly question...
    ... i want to tell you to hang on/in there, but i'm like you with the thoughts, ... i have people depending on me also, but it's been 4 years of up/down, they ... they've heaped us all together now as drug abusers so expect ...
    (alt.support.chronic-pain)
  • Re: X-Fest/RMGD Winter Conference: San Francisco
    ... > Will the aardvark be there? ... > Depending on the weather. ... > Please make sure, Neil, that Dave Kelly doesn't get tossed out before I ... It will be great to see you again, Joe. ...
    (rec.music.gdead)
  • Re: OT - This time theyre real
    ... the media respond certain ways depending on the ... There must be SOME reason they respond the way they ... to Mr. & Mrs. Obama. ... I'm not playing, Joe. ...
    (alt.autos.toyota)
  • Re: Impersonating user
    ... as Joe says - you need to auth the user to impersonate him. ... Depending on browser settings and other factors you can do that using windows authentication. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: red cells in DataGrid
    ... Just to add on to what Joe said; if you are rather trying to notify the user ... Rakesh Rajan ... depending on some other column values in the ...
    (microsoft.public.dotnet.languages.csharp)