title: Is it possible to concatenate column values into a string using CTE?
body: <p>Say I have the following table:</p>
  
  <pre><code>id|myId|Name
  -------------
  1 | 3  |Bob 
  2 | 3  |Chet
  3 | 3  |Dave
  4 | 4  |Jim
  5 | 4  |Jose
  -------------
  </code></pre>
  
  <p>Is it possible to use a recursive CTE to generate the following output:</p>
  
  <pre><code>3 | Bob, Chet, Date
  4 | Jim, Jose
  </code></pre>
  
  <p>I've played around with it a bit but haven't been able to get it working. Would I do better using a different technique?</p>