title: How to "Implode" (de-normalize/concat) multiple columns into a single column?
body: <p>I have a query which outputs something like this:</p>
  
  <pre><code>+-------+----+--------------+
  | F_KEY | EV | OTHER_COLUMN |
  +-------+----+--------------+
  | 100   | 1  | ...          |
  | 100   | 2  | ...          |
  | 150   | 2  | ...          |
  | 100   | 3  | ...          |
  | 150   | 4  | ...          |
  +-------+----+--------------+
  </code></pre>
  
  <p>I'm sure that I've seen an aggregation function which turns it (using <code>GROUP BY F_KEY</code>) into something like this:</p>
  
  <pre><code>+-------+------------+--------------+
  | F_KEY | ?          | OTHER_COLUMN |
  +-------+------------+--------------+
  | 100   | (1, 2, 3)  | ...          |
  | 150   | (2, 4)     | ...          |
  +-------+------------+--------------+
  </code></pre>
  
  <p>Means, it somehow "implodes" the values of <code>EV</code> together into one single field. How can I do this? Unfortunately, I don't remember the function's name.</p>
  
  <p>I'm using SQL Server.</p>
  
  <p>This is a simplification of my query:</p>
  
  <pre><code>SELECT
      F_KEY,
      EV,
      OTHER_COLUMN
  FROM
      TABLE1
  JOIN
      TABLE2 ON F_KEY = TABLE2.ID
  WHERE
      EVENT_TIME BETWEEN '2011-01-01 00:00:00.000' AND '2011-12-31 23:59:59.999'
  ORDER BY
      EVENT_TIME ASC
  </code></pre>
  
  <p>Any idea is appreciated!</p>