title: Display Parent-Child relationship when Parent and Child are stored in same table
body: <p>I have SQL Server table structure like below:</p>
  
  <pre><code>ID    Name     ParentID
  -----------------------
  1     Root       NULL
  2     Business   1
  3     Finance    1
  4     Stock      3
  </code></pre>
  
  <p>I want to display the details in my web page like</p>
  
  <pre><code>ID    Name     ParentName
  -------------------------
  1     Root      -
  2     Business  Root
  3     Finance   Root
  4     Stock     Finance    
  </code></pre>
  
  <p>How can I construct my SQL query?</p>