>>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
Hi Fred,
Close, but that one gives the following result
<b>artnr Jan Feb Mar Apr May ... Dec</b>
2 3 3 3 3 3
3 1 1 1 1 1
/Pierre
------------- if you cut here, you'll probably destroy your monitor ------------