title: Numbering Duplicates with sequential numbers
body: <p>Is this something which is possible in MS Access or SQL Server? I tried it in different ways using <code>GROUP BY</code> clause.</p>
  
  <p>I want to find out the duplicates (concatenating Sales Order and Item) with the sequential number. Column 'schedule' is what I am looking for.</p>
  
  <p><img src="https://i.stack.imgur.com/haIMu.png" alt="duplicates numbering"></p>