sql select parent child recursive in one field
<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>