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.