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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2007-03-05 : 07:39:31
|
| Hi I need to manipulate some client data into SQL.The data is in one column and I need it in sql in row format (one row per supplier):AAA123Address1Address2Address3PostcodeAAA456Address1Address2Address3Address4PostcodeABC567Address1address2Address3Address4Postcodeetc....Required output:AAA123 Address1 Address2 Address3 PostcodeAAA456 Address1 Address2 Address3 Address4 Postcodeetc...The supplier number is in a fixed format i.e. 3 alpha's + 3 numericsBUT the number of address lines can vary per supplier. Does anyone have, or can produce sample code so I can transform this data in SQL?Thanks! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-03-05 : 11:17:38
|
| hi khtan,dnf999 wants to achive through single column. in a link it reqd id so that it can be achive. any idea?Mahesh |
 |
|
|
|
|
|
column format to row format...