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 |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2001-05-15 : 14:10:06
|
| I have table called sc_fam_data which has a field called template_vars, this field will contain name value pairs as suchname1=val1;name2=val2...etc..I have a table called sc_widget_images which has a field called img and in it the values might be <%name1%>What would be the best way to scan through the sc_widget_images table and replace the template variables such as <%name1%> in the img field with the right name/value pair in the field template vars in the sc_fam_data table.I'm currently using a cursor but I know there is probably an easier solution using a string parsing function within an update statement which uses two tables. |
|
|
|
|
|
Substituting Template Variables