title: SQL Server - Return Max Value In One Column for All Rows
body: <p>I could use some help with SQL to solve the following problem.</p>
  
  <p>I have a table that has the following columns and data.</p>
  
  <pre><code>CUSTOMER PAYMENT_YEAR BILLS_PER_YEAR BILL_NUMBER
  Chris    2010         1              1
  Chris    2010         2              2
  Chris    2010         3              3
  </code></pre>
  
  <p>I would like to return all three rows but with the max bills_per_year value in all 3 rows.
  It would like like this.</p>
  
  <pre><code>CUSTOMER  PAYMENT_YEAR  BILLS_PER_YEAR  BILL_NUMBER
  Chris     2010          3               1
  Chris     2010          3               2
  Chris     2010          3               3
  </code></pre>