|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"SQL Server Recursive Fetch From Self Referencing Table"
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
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!