I have a table that looks like this:

<b>artnr    date</b>
2        1999-04-01
2        1999-05-01
2        1999-05-01
3        1999-04-01

And I want to have make something to get something like this

<b>artnr    Jan     Feb     Mar     Apr     May     ...    Dec</b>
2         0       0       0      1       2
3         0       0       0      1       0     

Anyone who can give some clues how to write the SQL-command? I could problably write some code to fix it, but there ought to be some cunning SQL-phrase that would take care of it for me.

/Pierre Unge, Sweden