title: Count maximum consecutive row out of total row for each day Ms-Sql
body: <p>I Want total number of row for each and for each day want consecutive max row count where condition numb>2 and calibration!=1 from table in pic below</p>
  
  <p><a href="https://i.stack.imgur.com/myuFN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/myuFN.jpg" alt="The table structure"></a></p>
  
  <p>and desire output should be </p>
  
  <p><a href="https://i.stack.imgur.com/tdCB4.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tdCB4.jpg" alt="The desired output"></a></p>