SQLTeam.com | Weblogs | Forums

Update and where simple code


#1

Hallo , need some help

update Artikel set nfiPreis0 = VK_Preis *0.8
where x_Preis_Code_art like 2016 and x_Preis_Rabatt_art like 99
update Artikel set Artikel_Changed = -1
where x_Preis_Code_art like 2016 and x_Preis_Rabatt_art like 99

how can I make this nicer...

now it makes 2 rounds

sorry i am really a code_dummy

thanks for your help


#2

update Artikel set nfiPreis0 = VK_Preis *0.8,
Artikel_Changed = -1
where x_Preis_Code_art like 2016 and x_Preis_Rabatt_art like 99


#3

:smiley: thank you very much...