title: SQL Server Concatenate GROUP BY
body: <p>I have a query that looks like this</p>
  
  <pre><code>SELECT J.JobID,T.Title FROM JobsTagMap J
  Left Join Tags T
  ON J.TagID=T.TagID
  </code></pre>
  
  <p>That returns the following dataset (simplified, JobID is actually a UniqueIdentifier)</p>
  
  <pre><code>JobID    Title
  1        Tag1
  1        Tag2
  2        Tag2
  2        Tag5
  2        Tag9
  </code></pre>
  
  <p>Now, i'd like to group this by the JobID-column and concatenate the Title, so the results is as following</p>
  
  <pre><code>JobID    Title
  1        Tag1,Tag2
  2        Tag2,Tag5,Tag9
  </code></pre>
  
  <p>How would i do that?</p>