List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:June 23 1999 3:23pm
Subject:Re: SQL DataCheck
View as plain text  
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 DataCheckSteve Ruby5 Jun
  • Re: SQL DataCheckMartin Ramsch23 Jun