On Fr, 1999-06-04 15:04:57 -0600, Steve Ruby wrote:
> For example if the interval for channel 7
> was 15 minutes and the table said
>
> DataDate DataTime DataChanID
> 1999/04/01 00:00:00 7
> 1999/04/01 00:15:00 7
> 1999/04/01 00:45:00 7
> 1999/04/01 01:00:00 7
>
> I would need to know that I am missing
> 1999/04/01 00:30:00
Steve, just quick an idea:
Create a new table Times which holds all times for the given interval
(or maybe a table with all relevant times that you later on filter
with intelligent WHERE clauses using modulo functions.)
Then you could do something like that:
SELECT ...what you need...
FROM Times LEFT JOIN Log
ON Times.Time = Log.DataTime
WHERE ISNULL(Log.DataTime);
Regards,
Martin
--
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7
Thread |
---|
• SQL DataCheck | Steve Ruby | 5 Jun |
• Re: SQL DataCheck | Martin Ramsch | 23 Jun |