469,086 Members | 1,287 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,086 developers. It's quick & easy.

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
Jul 30 '08 #1
4 1247
Delerna
1,134 Expert 1GB
huh ?????

Can you expand that?
Jul 30 '08 #2
ck9663
2,878 Expert 2GB
If you're using sql 2005, you can use PIVOT and UNPIVOT.

-- CK
Jul 31 '08 #3
dear plz send me query


thanxs
Aug 1 '08 #4
ck9663
2,878 Expert 2GB
More info please.

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


-- CK
Aug 1 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Xenophobe | last post: by
7 posts views Thread by Bing Wu | last post: by
reply views Thread by ward | last post: by
2 posts views Thread by =?Utf-8?B?Q2hyaXM=?= | last post: by
6 posts views Thread by Hemant Shah | last post: by
4 posts views Thread by Arun Srinivasan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.