That should work,

if you are looking at pivoting the data then you may find it useful to implement a calender table

http://codeinet.blogspot.com/2006/08/auxiliary-calendar-table-for-sql.html