title: How to transform rows to columns
body: <p>I have a simple problem when querying the SQL Server 2005 database. I have tables called Customer and Products (1->M). One customer has most 2 products. Instead of output as</p>
  
  <p>CustomerName, ProductName ...</p>
  
  <p>I like to output as </p>
  
  <p>CustomerName, Product1Name, Product2Name ...</p>
  
  <p>Could anybody help me?</p>
  
  <p>Thanks!</p>