title: Merge data in two row into one
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1874966/concatenate-row-values-t-sql">Concatenate row values T-SQL</a>  </p>
  </blockquote>
  
  
  
  <p>I'm new to SQL Server and had tried few techniques that suggested from internet like using temp variable, XML path, <code>COALESCE</code> and etc but all doesn't meet my requirement somehow. </p>
  
  <p>I'm using Toad for SQL Server version 5.5 to create SQL script and the account I used to query DB server only got READ access. Hence can't use <code>CREATE VIEW</code> statement I believe.</p>
  
  <p>Table Name : <code>Customer</code></p>
  
  <pre><code>ServerName  Country  contact
  ----------  -------  -------------
  srv1        SG       srv1_contact1
  srv1        SG       srv1_contact2
  srv1        SG       srv1_contact3
  srv2        HK       srv2_contact1
  srv2        HK       srv2_contact2
  srv3        JP       srv3_contact1
  srv3        JP       srv3_contact2
  srv3        JP       srv3_contact3
  srv4        KR       srv4_contact1
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>ServerName  Country  contact
  ----------  -------  -------------------------------------------
  srv1        SG       srv1_contact1; srv1_contact2; srv1_contact3
  srv2        HK       srv2_contact1; srv2_contact2
  srv3        JP       srv3_contact1; srv3_contact2; srv3_contact3
  srv4        KR       srv4_contact1
  </code></pre>