title: SQL/T-SQL - how to get the MAX value from 1 of N columns?
body: <p>In SQL/Transact SQL, I am trying to update a temp table to take the latest date from 3 different date columns (in that temp table), and put that MAX date into a "latest date" column.</p>
  
  <p>What is the best way to do this, using an update statement?</p>