Hello. Hi!

The problem is simple, but the answer doesn't seem so...

I'm trying to count the number of days per month per year between two dates.

So for the following 2 dates:

2013.12.15
2014.02.18
I would have something like:

Year | Month | Days

2013 12 16

2014 01 31

2014 02 18

So, with 2 dates, i would get as many rows as months between then.

I would like to achieve this using only a Select statement, but am completelu lost.

Anyone one out there can crack this? 😀