title: Any way to change a value on ODD/EVEN records in a sql Select statement?
body: <p>I just want to put in some false SQL Server 2008 database data to test the reports/charts in my app.</p>
  
  <p>Is there any way to do this based on an internal count and find out if the current record is odd (1,3,5,7, etc.)?</p>
  
  <pre><code>SELECT * FROM dbo.Table 
  (CASE WHEN @recordsetID isODD THEN IsAdmin = 1 ELSE IsAdmin = 0 END) 
  WHERE PassChange &lt; GETDATE() -65;
  </code></pre>
  
  <p><code>The @recordsetID isODD</code> value I am just making up to try and show what I mean. There is no AUTO-ID column in this particular Table.</p>
  
  <p>|Thanks|</p>