title: Breaking down progress(Percentage) through each quarter of the year in SQL Server
body: <p>Basically I am trying to calculate the progress of the current quarter, represented as a percentage.  Currently I have:</p>
  
  <pre><code>(DATEPART(dd,@AsOf)/91) * 100
  </code></pre>
  
  <p>We are using 91 days as a fixed solution for the quarter.  They necessity for 100% accuracy is not required.</p>
  
  <p><code>@AsOf</code> is being passed in as a <code>DATETIME</code> type.</p>
  
  <p>I have tried multiple ways and I receive 0.  I assume it is because I am using <code>INT</code> instead of <code>DECIMAL</code> but I tried that and I still get 0.</p>