title: sql select parent child recursive in one field
body: <p>I do not know how to select query recursive..</p>
  
  <pre><code> id     idparent    jobNO
  --------------------------------
    1         0         1
    2         1         2
    3         1         3
    4         0         4
    5         4         5
    6         4         6
  </code></pre>
  
  <p>how do the results like this With SqlServer</p>
  
  <pre><code> id     idparent    jobNO   ListJob
  ----------------------------------------
    1         0         1        1
    2         1         2        1/2
    3         1         3        1/3
    4         0         4        4
    5         4         5        4/5
    6         5         6        4/5/6
  </code></pre>