title: SQL group_concat function in SQL Server
body: <p>If there is a table called employee</p>
  
  <pre><code>EmpID           EmpName
  ----------      -------------
  1               Mary
  1               John
  1               Sam
  2               Alaina
  2               Edward
  </code></pre>
  
  <p>Result I need in this format: </p>
  
  <pre><code>EmpID           EmpName
  ----------      -------------
  1               Mary, John, Sam
  2               Alaina, Edward
  </code></pre>
  
  <p>Q: this record is in same <code>Employee</code> table. I have almost no experience using UDFs, stored procedures, I need to be done this thing through query.Is this possible without using UDFs, SP's.</p>