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-02 : 09:51:22
|
| 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 |
Posted - 2007-08-02 : 10:22:27
|
You need a CSV concatenating function.There are few here at SQLTeam. Please search.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2007-08-02 : 18:27:40
|
| tbraga,Did you figureout?If yes, please share the solution here.Thanks..... |
|
|
|
|
|
|
Pivot...