hierarchy query -- asp.net

Tem
1/12/2008 9:20:13 PM

I have a table that looks like this. Each row is a reply or a topic when
IsAReplyTo = 0
I need to write a query that pulls all rows of a hierarchy of a given ID

Table Forum
ID IsAReplyTo
4 0
9 4
27 4
63 27
73 0
82 63

given @ID = 63 it should return ID 4,9,27,82

Im not sure where to go from here.
Select * from Forum where IsAReplyTo = @ID

can it be done with a single query?

Tem

Mark Fitzpatrick
1/12/2008 10:28:29 PM

If you're using SQL Server 2005, you can use Common Table Expressions (CTEs)
to handle the recursive hierarchy. MS has some info about them at:
http://msdn2.microsoft.com/en-us/library/ms190766.aspx

and http://msdn2.microsoft.com/en-us/library/ms186243.aspx

They're a tad tricky to master, but once you get it down they can be
amazing.

--
Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression

[quoted text, click to view]

--CELKO--
1/13/2008 2:26:23 PM

[quoted text, click to view]

Yes. Look up the nested sets model for a quick way to do this without

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about asp.net

asp.net : hierarchy query