microsoft, sql server, database, date range query

folks

i have a following working calendar data

CALENDAR      START      END
DAYCAL      1/1/2008      1/31/2008

i have a another table called shift with the workshifts performed along the following days per week

SHIFT      DAYSTART      STARTIME      FINISHTIME
DAY      SUNDAY      7:00      15:00
DAY      MONDAY      7:00      15:00
DAY      TUESDAY      7:00      15:00
DAY          WEDNESDAY      7:00      15:00
DAY      THURSDAY      7:00      15:00
DAY      FRIDAY      7:00      15:00


how based on my data can I display my data as working time/days between 1-1-2008 and 1-15-2008

i.e like so

1-Jan      7:00      15:00
2-Jan      7:00      15:00
3-Jan      7:00      15:00
4-Jan      7:00      15:00
5-Jan      7:00      15:00
6-Jan            
7-Jan            
8-Jan      7:00      15:00
9-Jan      7:00      15:00
10-Jan      7:00      15:00
11-Jan      7:00      15:00
12-Jan      7:00      15:00
13-Jan            
14-Jan            
15-Jan      7:00      15:00


all help will be greatly appreciated!

rStart Free Trial