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 |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2008-01-18 : 05:36:10
|
| I have a table that looks like below.Table1id: text:1 1234, 33212 2222,6666,7777,8888,5555,33333 1234......I want to replace the values in the text column to other text values, for example 1234 = 'monkey' based on another table that contains the actual names:Table2id: name:1234 monkey3321 zebra2222 tiger......The result should be:Table1id: text:1 monkey, zebra......My idea is to separate the text based on the comma delimiter and insert the values in a temporary table and then along with it's idid: text:1 monkey1 zebra2 tigerand then concaternate and insert the new string in Table1.But how do I get this to work, any tips are helpful. |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-01-21 : 09:57:33
|
I suggest normalisation ;)id | text1 | 12341 | 3321etc
George<3Engaged! |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-21 : 10:59:44
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95755MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Search string and update row.