title: SQL converting backup size columns
body: <p>So I have this part of SQL script which I need to convert the two columns into <code>2 decimal point</code>.</p>
  
  <pre><code>convert (numeric(10,2),
  ROUND(SUM(msdb.dbo.backupset.compressed_backup_size)*8/1024, 0)) 
  as 'Compressed_Backup_Size in MB' ,
  SUM(msdb.dbo.backupset.backup_size/1024)/1024 
  as 'Backup_Size in GB'
  </code></pre>
  
  <p>My question is how do I get the two backup size columns to show the right value, I tried the conversion but the result it's still 894512.00 instead of 89.45 MB.. I have looked everywhere and they telling me to convert the numeric but still doesn't work for me. Help please</p>