On May 18, 2011, at 10:17 PM, Pavel Ivanov wrote: > SQL wasn't intended for and can't solve such tasks.
Of course it can. Assuming a calendar and an event table: select calendar.date from calendar where calendar.date between '20110101' and '20110201' and not exists ( select 1 from event where calendar.date between event.start_date and event.end_date) And where are analytics when one need them? :) http://www.orafaq.com/node/55 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users