Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2004-06-17 : 12:07:53
|
| For example.In a table I have 2 columnsCol A Col B AAA 1AAA 3AAA 2BBB 2BBB 3BBB 5I want to transpose this table to look like Col A Col B Col C Col D AAA 1 3 2 BBB 2 3 5Thanks |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-06-17 : 12:41:45
|
| Look At Pivot Table in BOLJimUsers <> Logic |
 |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-06-17 : 13:16:56
|
| Jim: You asked why? Because the data is being exported to Visual Foxpro, but the data structure is different, so it needs to be transposed.Thanks |
|
|
|
|
|
|
transposing data