need a query (columns to rows and rows to columns)

[muhammadrashidmughal]

columns f1 f2 f2 f4 f5 f6 f7 f8 ......
1
2
3
4
.
.
i have a table in which multiple columns and records more than 1000 ,
i need a query to convert these records in columns and columns in rows.

rashid

[Delerna]

huh ?????

Can you expand that?

[ck9663]

If you're using sql 2005, you can use PIVOT and UNPIVOT.

-- CK

[muhammadrashidmughal]

dear plz send me query


thanxs

[ck9663]

More info please.

How does your table look like and what's your desired output?


-- CK