title: SQL Server query to reduce numbers in a specific column by X %?
body: <p>I'd like to ask you guys how I can reduce numbers above +100,000 from specific column in SQL Server 2005 by X % via query ? I've searched around but didn't found a right way to do it.</p>
  
  <p>I'll give you an example: in database <code>OnlineGame</code> I've got a table <code>Monsters</code> and in that table there is a column of monsters' HP ... so, I want to lower all monsters that have +100,000 HP by X % ? Will be a much appreciated if that's possible to be done.</p>
  
  <p>To sum it up in a few words: All monsters that have 100,000+ HP to be lowered by X % in a specific column in that table.</p>
  
  <p>Kind Regards.</p>