Update multiple rows

[robbie123]

I have been struggling with (what I thought would be a simple Update query).

I have a number of info systems running on many different platforms I am trying to sync user info on them. I had written a simple script to create the SQL query to update the SQL DB's.
I assumed that something similar to (below) would work:
This works fine for one row, but as soon as I add a 2nd set/where statement I get a syntax error on "=":

Update mydatabase
Set location= 'nowhere', address = '123 nowhere st'
where employee_id = '12345'
Set location= 'somewhere', address = '123 somewhere ave'
where employee_id = '67890'

I would like to just be able to run the script every month and past a huge Update query into Interdev. Am I missing something stupid with the syntax or is there something fundimentally wrong with this logic???

 

[rac2]

You have two statements, thats all.

Update myTable Set
    location= 'nowhere',
    address = '123 nowhere st'
where employee_id = '12345'

Update myTable Set
    location= 'somewhere',
    address = '123 somewhere ave'
where employee_id = '67890'