Mass Update

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738773 More actions · Answer 1

Can you provide the table schem (DDL) as well as what changes you want to make. May be 2-3 lines of sample before and after data.

We can then help.

Steve Jones

maverick SSC Journeyman Points: 93 More actions · Answer 2

Here it is simplified.

I have a table for PC.

asset_tag, model_name, location_name, equipment_status

I have a list of 40 PC Asset Tags that need their location changed.

Antares686 SSC Guru Points: 125444 More actions · Answer 3

Try something like this:

UPDATE tblPC SET location_name = 'fillintheblank' WHERE asset_tag IN ('List','Of','Asset','Tags','Here')

as long as all the locations will be the same. But you can use for common groups as well just more update queries required.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

maverick SSC Journeyman Points: 93 More actions · Answer 4

SSC Journeyman

Points: 93

April 23, 2002 at 11:12 am

That did it. Thank you very much.