title: Using PIVOT on column with date or datetime values
body: <p>Here is my PIVOT query:</p>
  
  <pre><code>select * from t_interview_data
  pivot (avg (widgets) for 
  datestamp in ( [2009-11-01],[2009-11-02],[2009-11-03],[2009-11-04],[2009-11-05],[2009-11-06],[2009-          11-07]
  ,[2009-11-08],[2009-11-09],[2009-11-10],[2009-11-11],[2009-11-12],[2009-11-13],[2009-11-14],[2009-    11-15]
  ,[2009-11-16],[2009-11-17],[2009-11-18],[2009-11-19],[2009-11-20],[2009-11-21],[2009-11-22],[2009-11-23]
  ,[2009-11-24],[2009-11-25],[2009-11-26],[2009-11-27],[2009-11-28],[2009-11-29],[2009-11-30],[2009-12-01]
  ,[2009-12-02])) as AvgWidgetsPerDayPerEmp
  </code></pre>
  
  <p>My question is this: Although this query works, is there a more easier, simpler, more elegant way to write this?</p>
  
  <p>Sample output:</p>
  
  <p><img src="https://i.stack.imgur.com/L6LLY.png" alt=""></p>