title: ListAGG in SQLSERVER
body: <p>I'm trying to aggregate a 'STRING' field in SQLServer. I would like to find the same function LISTAGG like in Oracle .</p>
  
  <p>Do you know how to do the same function or an another method?</p>
  
  <p>For Example,</p>
  
  <pre><code>Field A | Field B
  1       |  A
  1       |  B
  2       |  A
  </code></pre>
  
  <p>And I would like that the result of this query will be </p>
  
  <pre><code>1 | AB
  2 | A
  </code></pre>