Dear Sir,

How can I write Select statement that return all the days in the current month or year... For example the results can be like:

1-1-05
2-1-05
3-1-05
4-1-05
...
...
...

Thank you in advance.