use of SortKey inside a CTE

• Santhoshkumar KB

  SSCertifiable

  Points: 5066

  More actions

  September 3, 2009 at 8:15 am

  #135829

  Hi,

  In the article at the below link, 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)

  http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/

  Please let me know.

  Thanks,

  KB

  Thanks,
  Santhosh
  

  ---

  Human Knowledge Belongs To The World !!

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 3, 2009 at 8:27 am

  #1048779

  If looks like it being used as a hierarchyID (new in sql2008), quite clever really.

  ---

  
  Clear Sky SQL
  My Blog[/url]