title: Comma separated values in one column - SQL SERVER
body: <pre>
  Customer Table
  --------------
  ID   Name
  1   James
  2   Peter
  </pre>
  
  <pre>
  Order Table
  ---------------
  OrderId  CustId
  100     1
  101     1
  102     2
  </pre>
  
  <p>How can I write a query that returns something like this</p>
  
  <pre>
  ID,Name,ListofOrders
  1,James,"100,101"
  2,Peter,"102"
  </pre>
  
  <p>In Sybase I had a function called LIST which I could use but I dont find a similar function in SQL SERVER</p>