gnidowd
asked on
SQL 2000 - Cross Tab Query
Dear Friends,
I have stated this is a cross tab query, but strickly it might not be, so looking for a better description.
I have two columns which contain data which I need to malipuate from a large table.
ColA ColB
1 1
1 2
1 3
2 4
2 5
2 6
I really need to get a query which will display the data
ColA ColB ColB ColB ColB
1 1 2 3
2 4 5 6
I really hope this is simple, but I have been stumped for a couple of days now, any help much appreacted.
Craig
I have stated this is a cross tab query, but strickly it might not be, so looking for a better description.
I have two columns which contain data which I need to malipuate from a large table.
ColA ColB
1 1
1 2
1 3
2 4
2 5
2 6
I really need to get a query which will display the data
ColA ColB ColB ColB ColB
1 1 2 3
2 4 5 6
I really hope this is simple, but I have been stumped for a couple of days now, any help much appreacted.
Craig
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are most welcome.
Happy coding!
Kevin
Happy coding!
Kevin
ASKER
Awesome, just what the doctor ordered.
Many thanks.
Craig