We use id, for example idProducts

I am trying to avoid the creation of a calendar table !!!

I need a result like the following

YEAR    MONTH     VALUE

2005       1           1234

2005       2       

2005       3            432.22

2005       4            23.00

2005       5            

2005       6             127.99

and so on ....

There is an Open Source Project: http://www.davidemauri.it/dabcos/

No I mean, to use the function in a similar way as the Aggregate function: SUM or COUNT or .....