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 |
|
abarsami
Yak Posting Veteran
68 Posts |
 Posted - 2003-03-27 : 14:41:28
|
| I have a table with 2 fields (company_id, memo)I want to convert data that looks like this:id memo1 a,b,ddd,eerere2 ff,ggInto this (insert new data in another table maybe):id memo1 a1 b1 ddd1 eerere2 ff2 ggI know how to do it in vb. Is there a stored procedure that can do this easily (does sql have a split function).thx |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-27 : 15:02:08
|
| [url]http://www.sqlteam.com/item.asp?ItemID=2652[/url]Sam |
 |
|
|
|
|
|
help with conversion