by --CELKO-- <jcelko212@[EMAIL PROTECTED]
>
Apr 14, 2008 at 07:37 AM
Build a look up table of "hhmm" strings (6 periods * 24 hours = 144
rows) then create a query for a given day like this:
SELECT @[EMAIL PROTECTED]
+ T.probe_time
FROM TimeSlots AS T
WHERE @[EMAIL PROTECTED]
+ T.probe_time
NOT IN (SELECT P.probe_time FROM ProbeReadings);
Acutally, an entire year of strings would be only (365 days * 144
slots) = 52560 rows, so you could put this in a VIEW and be ahead of
the game.
