Re: [SQL] Tough Problem -- Record Checkouts

2006-02-17 Thread Greg Stark
"Alfred" <[EMAIL PROTECTED]> writes: > CO| N > --+--- > 0 | 15-59 > 1 | 0, 16-59 > 2 | 0-1, 17-59 > 15| 0-14, 30-59 > 16| 0-15, 31-59 > 30| 0-29, 45-59 > 31| 0-30, 46-59 > 45| 0-44 > 46| 1-45 >

[SQL] Tough Problem -- Record Checkouts

2006-02-17 Thread Alfred
Imagine a library of books. Each book is a record. The library is the table. A user may check out a book and the shelf space it once occupied will store the minute that the user checked the book out. Every 5 minutes, a magical librarian walks through the library and when a book has been checked out