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

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

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

huh ?????

Can you expand that?

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

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

-- CK

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

dear plz send me query


thanxs

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

More info please.

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


-- CK