From http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/ Find Missing Numbers It is obvious that, to find missing numbers, we need to have a table or resultset which contains all the numbers. Then we can apply a NOT IN clause and identify the missing numbers. If you are wondering, why I needed missing numbers, here is the reason. In one of... Continue Reading →