Re: Nested sort, trying again
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 8 Oct 2005 16:11:52 -0700
Message-ID: <1128813112.002511.136580_at_g44g2000cwa.googlegroups.com>
Date: 8 Oct 2005 16:11:52 -0700
Message-ID: <1128813112.002511.136580_at_g44g2000cwa.googlegroups.com>
Frederic Brouard has a great article on using a recursive CTE to build
the path:
http://www.sqlservercentral.com/columnists/fBROUARD/recursivequeriesinsql1999andsqlserver2005.asp