Click here to Skip to main content
11,481,850 members (62,390 online)

Article Recommendation

Your Name:*
Your Email:*
Your friend's Email:*
The Message text:

Hi!,

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!

Additional text:
 
Note: the details entered on this page will not be stored or used for any purpose other than for sending this email.

Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 18 Nov 2007
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid