How to write a crosstab query?
i got one at access2000 but this doesn't work at sql server 2000

can anybody help me please?

it is like the following.
a table named SUBSCRIBERS
a table named INTERESTS
a table named SUBSCRIBERS_INTERESTS.

The query does the following:
IDSubscriber [IDOFINTEREST1] [IDOFINTEREST2] [IDOFINTEREST3] [....]
1 0 1 1
2 1 0 0
3 1 1 1

explanation: the subscriber with the id = 1 has got the interest with the id=2 and the interest with the id=3

each datarows of the INTERESTS-Table is a column at the query.

please help!

thx

This article shows the basic ways of generating a crosstab in SQL Server. http://support.microsoft.com/default.aspx?kbid=175574#3

Thank you for reply!
Sorry, this article can't help me, because the columns are dynamic!
so each column is a entry at the of the other table.

this is a resolution of a m:n relationship!

this is the reasion, why i wrote [...] at the example.

thx
Bernhard