how to convert 2 rows into one column

[kevinkwh]

i wannn convert the following.
thx in advance.

data table

desc nvarchar(100),
amount numeric(18,2)

FROM

desc amount

commercial 5000
commercial 8000

TO

desc amount1 amount2
commercial 5000 8000

[ck9663]

Check PIVOT/UNPIVOT in SQL Server.

Happy Coding!!!

~~ CK

[kevinkwh]

Ok !!! will try !!! thx alot

[kabilahan]

hi
check this to know about PIVOT

[kevinkwh]

Thx , It helps me alot .