Re: storing start/end times

[Peter Brawley]

> How am I suppose to "connect" the stores_open table with the calendar table

With a cross join, eg for the year 2015 ...

select c.d, s.open, s.close
from calendar c
cross join storesopen s
where s.sid=_STORE_ID_ and year(c.d)=2015;