title: Finding which COLUMN has a max( value per row
body: <p>MSSQL</p>
  
  <p>Table looks like so</p>
  
  <pre><code>ID    1   | 2  |  3  |  4  |  5 
  AA1   1   | 1  |  1  |  2  | 1
  </code></pre>
  
  <p>any clues on how I could make a query to return</p>
  
  <pre><code>ID  |  MaxNo
  AA1 | 4
  </code></pre>
  
  <p>, usign the above table example? I know I could write a case blah when statement, but I have a feeling there's a much simpler way of doing this</p>