title: SQL Server : round and add percent sign
body: <p>I have the following SQL query that is returning a result of <code>92.967013425802</code> and I need it to be formatted like <code>93%</code> and add the percent sign. I have tried changing the sum to round but I received an error </p>
  
  <blockquote>
    <p>The function 'round' is not a valid windowing function, and cannot be used with the OVER clause.</p>
  </blockquote>
  
  <p>My query:</p>
  
  <pre><code>select 
      count(*) * 100.0 / sum(count(*)) over()
  from 
      db_table_MetaData
  group by 
      MetaValue
  order by 
      MetaValue
  </code></pre>
  
  <p>Any help would be appreciated.</p>