title: Select column name of max date from each row in SQL/SSRS 2005
body: <p>How can I add the 'Last Step' column on the far right to a report in SSRS? Essentially, I need the name of the column that contains the most recent date from that row. Actual data will be a few thousand rows, each with ~15 dates. </p>
  
  <pre><code>Name      Step X      Step W      Step A      Step B      Step Y     Last Step
  -------------------------------------------------------------------------------
  John      1/21/2013   1/24/2013   1/3/2013    1/27/2013   1/7/2013   Step B
  Sally     1/22/2013   1/24/2013   1/12/2013   1/1/2013    1/5/2013   Step W
  </code></pre>
  
  <p><a href="http://www.sqlfiddle.com/#!3/916c1/1" rel="nofollow">SQL Fiddle</a> with simple example data.</p>