Click here to Skip to main content
12,063,909 members (63,781 online)
Click here to Skip to main content
Articles » Database » Database » General » Alternatives
Alternatives
Add your own
alternative version

Tagged as

Stats

8.8K views
6 bookmarked
Posted

SQL Server Recursive Fetch From Self Referencing Table

, 19 Nov 2009 CPOL
CREATE PROC GetChildNodes (@ID uniqueidentifier)ASBEGINWITH PermissionList (PermissionID, PermissionName, Level)AS(SELECT ap.PermissionID, ap.PermissionName, 0 AS LevelFROM Permission AS apWHERE PermissionID = @IDUNION ALLSELECT ap.PermissionID, ap.PermissionName, Level + 1FROM

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

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

Share

About the Author

Anish M
Web Developer
India India
No Biography provided

| | Privacy | Terms of Use | Mobile
Web03 | 2.8.160204.4 | Last Updated 19 Nov 2009
Article Copyright 2009 by Anish M
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid