[thelist] Iterate through result set - Is this possible? (SQL)

[Joshua Olson]

> -----Original Message-----
> From: Ken Schaefer
> Sent: Tuesday, May 31, 2005 6:43 AM
> 
> You can't "select" a 7 day gap. You can only select existing data. 

Ken,

Perhaps in a manner of speaking you can select a "7 day gap".  Back around
April, there was a suggestion to Burhan's previous question about this same
project (presumably) that may be able to help here.  The suggestion was to
enumerate all possible days (within reason, of course) and join the events
against that table.  Using an OUTER join, it would be possible to return
only those days that have no events, thusly returning the "gap".  Analysis
of this data (which can be done with one query) would allow you to locate a
range where a day, plus the 6 following days, are all within the results
set.

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/