search for: library_dates

...lists specific dates for an event, and with a recurrences table, which specifies the rules by which an event recurs. I then have a table which simply enumerates dates up to an event horizon, and I get all events on dates in whatever range I''m looking at with a query like: SELECT events.*, library_dates.start_date FROM library_dates LEFT OUTER JOIN events ON 1=1 WHERE events.id IN (SELECT event_id FROM recurrences WHERE monthday IS NOT NULL AND DATEPART(dd, start_date) = monthday OR (monthday IS NULL AND weekday IS NOT NULL AND DATEPART(dw, start_date) = weekday AND (monthweek IS NULL OR d...