View Single Post
  #10 (permalink)  
Old June 12th, 2008, 01:36 PM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

To Planoie:

Yes, I mentioned that SQL Server 2005 had recursion capabilities that I hadn't yet used.

Granted, using a "path" is much better used for read-only data. But there are tons of examples of such data in the real world. For example, forum posts. (Well, if the forum code is smarter than this mildly braindead one, such that you can reply to a particular message instead of just to the topic/thread.)

Anyway, he doesn't have a path, just the it/parentid relationship. So if you could show him how to produce his desired output using SQL Server 2005 recursion, it would be appreciated, I'm sure!
Reply With Quote