July 30th, 2009, 08:52 AM
|
|
Registered User
|
|
Join Date: Feb 2009
Posts: 2
Time spent in forums: 48 m 21 sec
Reputation Power: 0
|
|
SQL Cursor To Find Missing Date Entries
Hi There..Im trying to use a cursor to find missing weekly entries from a table, the problem is im new to sql and dont know if this is even possible?
My table looks something like this;
| Account | Date | Bal |
| 17345 | 05/01/09 | 100 |
| 12376 | 05/08/09 | 135 |
| 12547 | 05/22/09 | 123 |
| 12331 | 05/29/09 | 112 |
| 12341 | 06/05/09 | 118 |
| 13475 | 06/19/09 | 114 |
In this case the missing weekly entries are 05/15/09 and 06/12/09, so idealy if i could have a cursor that would automatically go through the table, find missing date entries and display these missing dates in a different table it would be awesome..if anyone has any idea on how this could be done it would be very much appreciated!
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
