I have a table that uses a Date field as its primary key. Each date in use happens to be a Monday and there are records for every single Monday for the past 6+ years. This means that for a given row, the row below it is always 7 days before it.
Each ...