title: Concat multiple line in one
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string">Concatenate many rows into a single text string?</a><br>
    <a href="https://stackoverflow.com/questions/451415/simulating-group-concat-mysql-function-in-microsoft-sql-server-2005">Simulating group_concat MySQL function in Microsoft SQL Server 2005?</a>  </p>
  </blockquote>
  
  
  
  <p>I'm working with MS Sql Server 2008,
  I have the following table</p>
  
  <pre><code>----------------
  Uid | Alias |
  --------------- |
  1 | Pierre |
  1 | Patrick |
  1 | Jean |
  2 | Alice |
  2 | Diana |
  </code></pre>
  
  <p>and I want to display it in this manner:</p>
  
  <pre><code>------------------------|
  Uid | Alias |
  ------------------------|
  1 | Pierre Patrick Jean|
  2 | Alice Diana |
  </code></pre>
  
  <p>Any idea will be appreciate.</p>