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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 USING A LOOP TO DO A MASS UPDATETEXT

Author  Topic 

jimmy.hunt
Starting Member

21 Posts

Posted - 2006-04-13 : 10:11:16
Here is the script I'm using:
http://www.aspfaq.com/show.asp?id=2445

I'm using this script to do a updatetext on a ntext field. Can someone tell me if there is a way to have a table of orignal and replacement strings and then do a loop with those values and use this script to do multiple replacements.

Thanks!
James

James Hunt

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-19 : 04:19:15
http://sqlteam.com/forums/topic.asp?TOPIC_ID=64710

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -