Rows to Columns 1

[xxing]

Hi

I have a table that has rows which I want to convert to columns

e.g.

#Fruit
COL1
Apple
Pear
Orange

I want a table that has
COL1 COL2 COL3
Apple Pear Orange

The #Fruit table can have 3 or more rows.
The names of the fruit can differ

Can this be done?

Thank you
Mark

 

[hmckillop]

if you have sql 2005 you can use the pivot command does exactly what you need

no point in me retyping - here is a good link explains it all
[link]http://technet.microsoft.com/en-us/library/ms177410.aspx[/url]


"I'm living so far beyond my income that we may almost be said to be living apart