title: Without PIVOT, display data where GROUP BY column are the column names
body: <p>I have data that looks like the following:</p>
  
  <pre><code>Name    Date         Hr     Min    Amt
  Joe     20150320     08     00     5
  Joe     20150320     08     15     3
  Carl    20150320     09     30     1
  Carl    20150320     09     45     2
  Ray     20150320     13     00     8
  Ray     20150320     13     30     6
  </code></pre>
  
  <p>A simple GROUP BY [Name], [Date], [Hr] would display the total by hour for each salesman.</p>
  
  <p>Without using PIVOT or dynamic sql, how can I display this data where the hours are the columns? With PIVOT I would need to detail each hour, so if the data above were the only data, there would be 3 columns with data (8, 9, 13), and 21 empty columns.</p>
  
  <p>The reason I want to do this is because I would like to create an SSRS report where the columns are the hours. Unfortunately, I can't use a matrix because I can't sort by the column detail (ie. click on "8" and display from smallest to largest); I've already confirmed this limitation with an MS expert.</p>
  
  <p>So any help is appreciated. We have Sql Server 2008 R2.
  Thanks.</p>