Recursive queries?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SLE (info_at_NOSPAM.dataworx.be)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 08:40:57 +0100

Hi there,

Categories are persisted in the following table. This illustrates that
categories can have child categories (or in other words categories can have
a parent category).

tblCategory
CatID int
CatName nvarchar(255)
CatParent int (nullable)

I need some generic T-SQL which will return all n-level categories.

Thanks, 

--
SLE