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
------------- if you cut here, you'll probably destroy your monitor ------------
