title: SQL Server: Create sequence column based on a non-distinct column
body: <p>I'm not sure if I'm asking this question right, but hopefully I can explain it well enough. I have a table that has a Date, Value, and WeekEndDate column. I want to create a sequence column that counts the  distinct weeks from 1-13 and cycles every 13 weeks.</p>
  <p>I attached a small sample of the output I'm trying to create. Is this even possible?</p>
  <p><img src="https://i.stack.imgur.com/VMOe6.png" alt="Desired Table Output" /></p>