Solved

SQL Update Querry

Posted on 2013-01-14
5
185 Views
Last Modified: 2013-01-16
Can someone please tell me what update command I need in order to do this? I will need to do a mass change to all records with the following operation ID "1AC_"
Where Description is "RECIEVING" changed to read "RECEIVING / PRELIMINARY INSPECTION"
There are probably over 3 thousands records so I was wondering if someone could please tell me a querry to update the description on the table for specific records (operation ID "1AC_" )

Here is the table:
table
0
Comment
Question by:pauledwardian
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 333 total points
ID: 38777116
Update tablename

set description='RECEIVING / PRELIMINARY INSPECTION'
where Operation_Id='1AC_'
and description = 'RECIEVING'

try this
let us know if any problem
0
 

Author Comment

by:pauledwardian
ID: 38778508
Thank you for your responce.
The Operation_Id always starts with "1AC_" but it has other characters attached to it like:

1AC_692545-17/-18
1AC_3886225
1AC_319545
 ...

And also the description is either like "RECEIVING:" (with collon) and in some cases "RECEIVING" (without the collon).

Can you please help?

Thank you,
Paul
0
 
LVL 32

Accepted Solution

by:
awking00 earned 167 total points
ID: 38778595
Update tablename

set description='RECEIVING / PRELIMINARY INSPECTION'
where Operation_Id like '1AC_%'
and description like 'RECEIVING%'
0
 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 333 total points
ID: 38782225
Update tablename

set description='RECEIVING / PRELIMINARY INSPECTION'
where Operation_Id like '1AC_%'
and ( description = 'RECIEVING' OR description = 'RECIEVING:' )
0
 

Author Closing Comment

by:pauledwardian
ID: 38784593
Thank you all
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question