>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

Look at VPFXTAB.PRG that ships with VFP. IT would be easier to run an SQL SELECT to get the data you want, then run it through VFPXTAB to get the final result.