Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Srinivas Sampath Recursive Queries in SQL Server 2005 RE: Recursive Queries in SQL Server 2005

  • September 3, 2009 at 8:38 am

    #1048788

    Dave Ballantyne (9/3/2009)

    KB (9/3/2009)

    Hi,

    In this article, I need to know what is the purpose of SortKey in CTE.

    In the hierarchy, will the Top level row is returned first??

    (In our project we need only the top row - so it is important that the row returned is correct)

    Please let me know.

    Thanks,

    KB

    Please dont cross post

    http://www.sqlservercentral.com/Forums/Topic782210-338-1.aspx

    Sorry for that...

    I didn't know whether this Discussion is active or not, so I posted here too..

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!