title: SQL Server: mutiple records merge to a same row with the same ID
body: <p>I have a table look like this: </p>
  
  <pre><code>P_ID    Lang   
  1001    EN
  1001    German 
  </code></pre>
  
  <p>Expecting result:</p>
  
  <pre><code>P_ID Lang1  Lang2  
  1001  EN     German
  </code></pre>