;WITH cte AS
(
	SELECT catId,catName FROM Category WHERE catid = @catid
	UNION ALL
	SELECT c.catId,c.CatName FROM 
	Category c INNER JOIN cte t ON t.parentCatid = c.catId
)SELECT * FROM cte;