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 |
|
tbraga
Starting Member
11 Posts |
 Posted - 2007-08-01 : 13:06:47
|
| Hi All, I'm in a little bit of a dilemma. I have a resultset that brings back one column but multiple rows. I need someway of modifying my statement so it brings row 2 as row 1 column 2 and row 3 as row 1 column 3 ect...Does this make sense or can this even be done?Any help would be great, Thanks!Tim |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-01 : 13:17:11
|
| Search these forums for PIVOT.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tbraga
Starting Member
11 Posts |
Posted - 2007-08-02 : 07:59:02
|
| Good idea, but I thought pivot tables were only for numeric values and not varchars ect...is this true? |
|
|
|
tbraga
Starting Member
11 Posts |
Posted - 2007-08-02 : 08:14:05
|
| Basically this is what I have to work with and this is what I'm looking for...ColA ColB ColC1 MARKETING Adobe Acrobat 2 MARKETING Cisco VPN 3 MARKETING Citrix ICA 4 Human Res MS Office 5 Human Res Symantec Need it to Look like below,1 Marketing Adobe Acrobat CiscoVPN Citrix 2 Human Res Office SymantecLittle help...?Thanks!!!Tim |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
tbraga
Starting Member
11 Posts |
Posted - 2007-08-02 : 09:14:37
|
| Darn it doesn't work with SQL 2000, |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-02 : 09:42:51
|
SQL 2000? You have posted on a SQL2005 forum...
E 12°55'05.25"N 56°04'39.16" |
|
|
|
tbraga
Starting Member
11 Posts |
Posted - 2007-08-02 : 09:50:14
|
| wow this sucks, i'll post it in the 2000 section. thanks, |
|
|
|
|
|
|
Turn rows into columns