title: SQL Increment field from values X to Y
body: <p>I'm trying to get a field to increment by @increment between two variables @start and @end, resetting at @end and beginning again with @start and continuing for all rows in the table.</p>
  
  <p>If </p>
  
  <pre><code>@start = .06 
  @end = .10
  @increment = .02
  </code></pre>
  
  <p>Then I'm looking for something like:</p>
  
  <pre><code>1 .06
  2 .08
  3 .10
  4 .06
  5 .08
  6 .10
  </code></pre>
  
  <p>I've tried using Row_Number() with a modulo, but it doesn't work after the first reset. </p>