Re: query to trace all parents
From: Stefan Rybacki <stefan.rybacki_at_gmx.net>
Date: Fri, 24 Jun 2005 18:03:38 +0200
Message-ID: <3i2p6qFjf4r7U4_at_individual.net>
Date: Fri, 24 Jun 2005 18:03:38 +0200
Message-ID: <3i2p6qFjf4r7U4_at_individual.net>
Mark D Powell wrote:
> Sorry about asking what database. I had open mutiple screens and
> though I was on the theory borad. I do not think that MS SQL Server
> has a "connect by" clause unless the 2005 version introduces it so you
> will need to design your process using either multiple tables or
> procedures.
No you don't. "Nested Sets" is a keyword.
>
> -- Mark D Powell -->
Received on Fri Jun 24 2005 - 18:03:38 CEST