converting rows into columns
i wanted to convert my all the data of one table into column name.
ex.: name dept
------- -------
X A
Y B
Z C
Desired Out put is ---
name dept A B C X Y Z
------ ----- -- -- -- -- -- --
X A
Y B
Z C
Required out put in SQL query.
Thanks,
Rakesh Mishra