title: What are some good ways to transpose data in a SQL table from row-columns to column-rows?
body: <p>What are some good ways to transpose data in a SQL table from row-columns to column-rows?</p>
  
  <p>Also allowing filters/where conditions to be applied on the initial query.</p>
  
  <p>Using SQL Server 2008.</p>
  
  <p>Existing table has following Columns:
  AID (nvarchar unique)
  ASID (nvarchar unique)
  Milestone (M1, M2, M3...M100)
  MilestoneDate (datetime)</p>
  
  <p>Transposed data as follows:
  AID, ASID, M1 Date, M2 Date, M3 Date, M5 Date</p>