title: How to Concatenation Parent-Child Rows on Hierarchical table in SQL Server?
body: <p>I have a table Address and I want to Concatenation rows like parent-1 => parent-1/all-child, parent-2 => parent-2/all-child so on ....</p>
  
  <p>Address Table</p>
  
  <pre><code>ID   Caption   Parent
  ---------------------
  1    A          NULL
  2    B          NULL
  3    a          1
  4    b          2
  5    bb         4
  6    C          NULL
  7    aa         3
  8    c          6
  </code></pre>
  
  <blockquote>
    <p>NULL Parent is is mean Root</p>
  </blockquote>
  
  <p>Desired output</p>
  
  <pre><code>ID   Caption   Parent
  ---------------------
  1    A          NULL
  3    A/a        1
  7    A/a/aa     3
  2    B          NULL
  4    B/b        2
  5    B/b/bb     4
  6    C          NULL
  8    C/c        6
  </code></pre>