Thread: Crosstab query
View Single Post
  #1 (permalink)  
Old September 17th, 2004, 03:45 AM
Berni016x Berni016x is offline
Registered User
 
Join Date: Nov 2003
Location: , , Austria.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Berni016x
Default Crosstab query

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

Reply With Quote