Click here to Skip to main content
13,050,429 members (82,479 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions


38 bookmarked
Posted 26 Apr 2009

T- SQL - How to get all descendants of a given element in a hierarchical table

, 13 May 2009
This article provides a T-SQL table valued function that retrieves all the descendant rows of a given row in a hierarchical table.



Compare Revision Minor Date Status Editor
5 - publicly available No 13-May-09 10:47 Available Smitha Nishant
4 No 13-May-09 10:49 Composing Smitha Nishant
3 No 26-Apr-09 10:12 Composing Paolo Costa
2 No 26-Apr-09 9:01 Composing Paolo Costa
1 No 26-Apr-09 8:58 Composing Paolo Costa


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Paolo Costa
Software Developer (Senior)
Italy Italy
Paolo Costa is a software developer with long experience on any kind of .NET application. He lives in Italy and works in Switzerland for a credit card payment acquiring company.

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170713.1 | Last Updated 13 May 2009
Article Copyright 2009 by Paolo Costa
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid