1. Recursion or 2. A while loop over a table variable ~Brad
-----Original Message----- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Monday, January 30, 2006 6:41 PM To: CF-Talk Subject: Nested Set Model Hi there, I have the following category table which utilises a nested set model... CREATE TABLE [dbo].[categories] ( [cat_id] [int] IDENTITY (1, 1) NOT NULL , [dModified] [datetime] NULL , [dCreated] [datetime] NULL , [cat_parent_id] [int] NULL , [cat_lft] [int] NULL , [cat_rgt] [int] NULL , [cat_image] [varchar] (255) COLLATE Latin1_General_CI_AS NULL , [cat_sort_order] [int] NULL ) ON [PRIMARY] GO What I wish to add to the table is a level column, eg. the top most parent nodes would be level 1, their children level 2 and so on... I am a bit stumped as to how to create a query (I am using SQL Server 2000) that will determine what level a particular record is in the hierarchy? Any help would be really appreciated. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230792 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
