title: Count mismatch in sql browser and java JDBC, due to high transaction
body: <p>I'm using SQL Server 2005. There is more concurrent access on this <B>table1</b>. </p>
  
  <p>When I execute the following query in SQL Browser I'm getting 2000 records, but when the same query is executed with java, no of records r varied. </p>
  
  <pre><code>EX: 1st execution --&gt; 2000 records,
      2nd execution --&gt; 2005 records, 
      3rd execution --&gt; 1990 records
  
  
   select 
       REGISTRATION_NO as TOTAL_ASSETS_COUNT 
   from 
       Contable1 a 
   inner join 
       table2 b on a.REGISTRATION_NO = b.Registration_no 
                and a.System_id = b.System_id 
   inner join 
       table3 c on b.Registration_no = c.VehicleNo 
                and b.System_id = c.System_id 
   where 
       a.CLIENTID = ? and a.System_id = ? and b.User_id=?
  </code></pre>
  
  <p>I'm using isolation level as <b>READ COMMITTED</b>.</p>
  
  <p>Due to high transaction on <B>table1</b> the count is varied. </p>
  
  <p>Please help to resolve why the count is varied in java.</p>
  
  <p>NOTE: <code>Registration_No</code> is the primary key.</p>
  
  <p>Thanks in advance.</p>