>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

How about:

SELECT artnr, ;
COUNT(MONTH(date)=1) AS Jan, ;
COUNT(MONTH(date)=2) AS Feb, ;
etc ;
FROM MyTable GROUP BY artnr