title: SQL Server Row_Count with Reset
body: <p>I have 6 columns:</p>
  
  <pre><code>Date, Account, Side, Symbol, Currency, Reset Flag (0 Yes, 1 No)
  </code></pre>
  
  <p>I want to row count over partition by but reset the row count whenever a 0 appears in <code>Reset Flag</code> column. The first 5 columns are not unique but their combination forms a unique set of columns.</p>
  
  <p>Please help me with this !</p>
  
  <p>Every other solution I've researched doesn't work for some reason :/</p>