title: output the column name with the highest value
body: <p>I have a lot of columns with numbers in them in a SQL Server table. 
  I need to check the specific columns for the highest number and output the name of the column for each row in the table.</p>
  
  <p>For example:</p>
  
  <pre><code>RED | BLUE | GREEN | BLACK | Highest Column
  
  0      2       1       4         BLACK &lt;-- Outputted result of an expression
  </code></pre>
  
  <p>I have a dataset that pulls all the columns from the database table. 
  I need an expression that will evaluate the data and return the highest valued column name. </p>
  
  <p>I'm not sure of the logic behind this type of situation. Any help would be appreciated.</p>
  
  <p>This is an SSRS report.</p>
  
  <p><img src="https://i.stack.imgur.com/7HDei.jpg" alt="Need to find the biggest value of all these columns for each row"></p>