Get Children
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi, How can I get all children in just one level downer than a parent in hiererchy in SQL Server 2008?
Best wishes
-
Hi, How can I get all children in just one level downer than a parent in hiererchy in SQL Server 2008?
Best wishes
Typical example, organ area problem. The table name is organ: ID OrganName ParentID 1 A 0 2 a 1 3 b 1 SELECT a.* from organ as a, organ as b where a.ParentID=B.ID The result is: ID OrganName ParentID 2 a 1 3 b 1
April Comm100 - Leading Live Chat Software Provider