How to find gaps in sequential non-auto-increment column

[stevieontario]

Evening Freaks,

 

I am trying to identify gaps in a column that holds hourly versions of files -- i.e., this column contains only numbers between 1 and 24.

 

Rows are added to this table every hour, so that this column -- called Version -- would, if this were a perfect world, always contain repeating sequences of 24 rows. The Version column would always contain numbers in sequence, 1 to 24, and repeating until the end of time.

 

Of course in the real world, rows sometimes don't get added. I want to find the instances where there is a gap, and then manually add the rows.

 

Any idea on what kind of query would help me find these gaps?

 

Thanks in advance,

 

Steve

 

 

[fenway]

You can left join to a derived table with 24 such rows.