[SQL] finding gaps in dates

2004-11-16 Thread Matt Nuzum
I have a logging application that should produce an entry in the database every minute or so, give or take a few seconds. I'm interested in finding out a: what minutes don't have a record and b: periods where the gap exceeded a certain amount of time. The only way I can think of to do it is to

[SQL] Suggestions on storing re-occurring calendar events

2004-08-09 Thread Matt Nuzum
Hello, I've got an application and there is something that I just cannot get figured out. I currently store a bunch of events for various calendars in related tables that look like this: ftr_cal_master Column | Type | Modifiers +---+---