Link to home
Start Free TrialLog in
Avatar of gnidowd
gnidowdFlag for United Kingdom of Great Britain and Northern Ireland

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

 
ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gnidowd

ASKER

mwvisa1,

Awesome, just what the doctor ordered.

Many thanks.

Craig
You are most welcome.

Happy coding!

Kevin