How to pivot a table in sql2005/sql2000-convert row to colmns

[Anoop Brijmohun]

Hi Guys, I need to convert rows to columns, I have a table shown below ColA....ColB X XX X YY X ZZ do you know how to query this table to get a result set like this below ColA...ColB...ColC...ColD X XX YY ZZ I have tried to use a pivot query but fail to get the desired output, please help, thanks in advance Anoop