Hello all,

Is there a way using T-SQL that I can select all dates in a given month? I do not want to put the dates in a table and select them that way. I want to be able to say:

Select 112007

(for example and 30 dates are returned.)

11/1/07
11/2/07
11/3/07
'etc.

can this be done?

Thanks,

Strick