title: Reset Auto Increment by day in visual studio - SQL
body: <p>I´m looking for an solution to reset the auto increment id by day change.</p>
  
  <p>Let's say you have a order and you want to store 2 identification numbers...
  the daylie order number and the order itself.</p>
  
  <p>E.g. ORDER#123123 ORDERDAY#3 Article#Something, etc.</p>
  
  <p>The order number will be auto increment and primary while the day id will be just a counter to see how many orders the company got in a day.</p>
  
  <p>The day counter has to reset itself by new day.</p>
  
  <p>I´m currently working on a windows forms project with a local SQL Server database.</p>
  
  <p>Thanks in advance</p>