InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:38:50 GMT20http://www.sqlservercentral.com/Forums/Topic1073973-391-1.aspxYou'll need a recursive CTE for that.This MSDN article explains the concept:[url]http://msdn.microsoft.com/en-us/library/ms186243.aspx[/url]Mon, 07 Mar 2011 03:41:29 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1073973-391-1.aspxI am using sql server 2008 enterprise editionI have Account Table like this.AccountID Name ParentID1 Account 02 Asset 03 Expensess 14 Building 25 Income 16 Small Expenses 37 small Income 58 Furniture 4and so onIf i got 0 then that is main account.until we have to search it has to get.All accounts related to parent accounts Account and Asset onlyif i am retrieving account id=7then out put is like thisAccountID Name ParentAccountName 7 small Income Accountif i am retrieving account id=8then out put is like thisAccountID Name ParentAccountName 8 Furniture AssetLike this i have to get output.How to write Query for thisThank's in AdvanceMon, 07 Mar 2011 00:55:08 GMTranga.402