convert the rows to columns

[Fatih235]

hello

i have a table called test. This is the table,

test_id test_date test_description
1 1/1/2001 test1
2 2/1/2001 test2
3 3/1/2001 test3

I want to get the results like this,

test_id 1 2 3
test_date 1/1/2001 2/1/2001 3/1/2001
test_description test1 test2 test3


How can i do that? Thank you.

 

[JohnDTampaBay]

Check out these FAQs to see if they help. Good luck!
Crosstab Query - PART I (Code Generator) faq183-5269
Crosstab Query - PART II (Dynamic Execution) faq183-5278


--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Fatih235]

Isnt there an easier way to do this?