Re: Extracting Parent Model from Nested Sets Model
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 22 Jan 2003 11:08:58 -0800
Message-ID: <c0d87ec0.0301221108.10e5d0f1_at_posting.google.com>
Date: 22 Jan 2003 11:08:58 -0800
Message-ID: <c0d87ec0.0301221108.10e5d0f1_at_posting.google.com>
>> Does that work in SQL Server? <<
No. The adjacency list model would have a (parent, child) table as a
result. This query simply gives meaningless numbers. Yout query does
not translate into SQL.
What is the logic? Is there a looop hidden in the syntax?