SQL Select all days in a year with 9 blank INT fields

I am trying to get all dates in a year in a SELECT statement with 9 INT fields that have a value of 0 in them.

So basically I need the following:

1/1/2007 0 0 0 0 0 0 0 0 0
1/2/2007 0 0 0 0 0 0 0 0 0
1/3/2007 0 0 0 0 0 0 0 0 0 

and so on and so on for a whole year.

The year is always the 1/1 - 12/31

This is part of a bigger query but I don't think that part is necessary as this is the part I need....

Thanks!

5
задан RedFilter 25 October 2010 в 14:24
поделиться