title: Increase row count in sql server after some count (say 25,000)
body: <p>I have table like this  </p>
  
  <pre><code>col1 col2 col3
  3   5    8    
  4   5    5    
  5   5    5    
  3   3    3    
  4   5    6 
  </code></pre>
  
  <p>I need to get table like below in SQL Server   </p>
  
  <pre><code>col1 col2 col3  group 
    3   5    8    1
    4   5    5    1
    5   5    5    2
    3   3    3    2
    4   5    6    3
  </code></pre>
  
  <p>After some row count (say 25000 ) group column row count has to increase</p>
  
  <p>(ex- if row count crosses 25,000 the group column value has to change to next number ie 25,001 - 2, 50001 - 3)</p>
  
  <p>How to write a query in SQL Server?</p>