Find Missing Date Ranges in SQL (simple-talk.com)
Often, the quickest way to determine whether you have missing data in a table such a ledger or journal is to see if there are gaps in the dates where one wouldn't expect them. But how do you do that in an emergency, particularly in a large table, when every minute counts?
Download:
TSQL Source Code
No comments:
Post a Comment