title: Using TSQL how to Group By a Value and create a delimited string of ID
body: <p>Using TSQL Group by how to get from </p>
  
  <pre><code>Id value
  
      1  a
      2  b
      3  b
  </code></pre>
  
  <p>To</p>
  
  <pre><code>Ids Value Quantity
  1    a    1
  2,3  b    2
  </code></pre>