query to get number of childs from parent child table

[sepel]

hi i have a table that store my subject. each subjct has a parentid that refer to one subject id in itself table. how can i write query that return subject with number of there childs?

sepel

[Blue_Boy]

Where are stored childs of subject? In which table?

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[razov]

can you give structure of tables you are talking about and structure of output you need?

[Paddy Boyd]

You might want to have a google and look at recursive common table expressions (CTE) (if you're on SQL2005).