Need assistance for an update statement on live DB (MSSQL 2000)
Posted on 2008-10-02
I am at am impasse with a update statement I am trying to create so I thought I would just break down and ask for help!
What I am trying to do is create an update statement to modify our casino database in order to correct a LOT of typo's in our business source code field which is known as sourcecode in the database. I have made a query that basically says is this sourcecode = X change it to Y but then I have to run it EACH time on EACH sourcecode to change and what I was wanting to do was an easier way, I want to make a loop and list EACH sourcecode that needs to be changed perhaps a select statement and have it change it to the proper format. Sorry to sound like I am running off but I dont know else to explain it. I dont have any good snippets to submit because I really cant figure out how to put it together in my head.
Here is an example of some changes that should be made although there are 100's more:
IS should be
WATCH LIST WATCHLIST
On this particular case I dont have a best guess to offer... Sorry! Please note we are running SQL 2000.