I'm updating a column as follows :
UPDATE table
SET Office = 'ANR'
WHERE Department = 'SE'
GO
UPDATE table
SET Office = 'BRU'
WHERE Department = 'AI'
Is there a way I can do this in one run ? I was thinking about setting a variable depending on the 'Department' value and updating the column with this variable.
Erik Verstichel
Panalpina World Transport.
Antwerp, Belgium
UPDATE table
SET Office = 'ANR'
WHERE Department = 'SE'
GO
UPDATE table
SET Office = 'BRU'
WHERE Department = 'AI'
Is there a way I can do this in one run ? I was thinking about setting a variable depending on the 'Department' value and updating the column with this variable.
Erik Verstichel
Panalpina World Transport.
Antwerp, Belgium