title: How to get comma-separated values in SQL Server?
body: <p>I have two tables called <code>tblEmployee</code> and <code>tblWorkPlace</code>. The second table consists of multiple rows for each employee. I want to get the result as follows</p>
  
  <pre><code>EmployeeName   WorkPlace
  Gopi           India,Pakistan,...
  </code></pre>
  
  <p>I.e. if <code>tblWorkPlace</code> consists of multiple rows for an employee, I want the result in a single row, with data being separated by commas.</p>
  
  <p>How will I get this result ????</p>