yokotec Posted July 27, 2005 Report Share Posted July 27, 2005 Servus , ich suche einen SQL BEfehl der alle Artikelpreise um, 16% senkt. Hoffentlich hilft mir einer Gruss und Danke YOKO Link to comment Share on other sites More sharing options...
BareboneF Posted July 27, 2005 Report Share Posted July 27, 2005 UPDATE products SET products_price = products_price/116*100 Link to comment Share on other sites More sharing options...
yokotec Posted July 28, 2005 Author Report Share Posted July 28, 2005 1000 Dank f?r Deine Hilfe - Hat super funktioniert Das hat mir echt den "Hintern" gerettet LG YOKO :laugh: Link to comment Share on other sites More sharing options...
smedder Posted July 29, 2005 Report Share Posted July 29, 2005 Damit wurden aber nicht alle Preise um 16% gesenkt. Es wurden lediglich aus Bruttopreisen Nettopreise. Wenn du das meintest, war das ja soweit richtig. Andernfalls mach es wieder r?ckg?ngig mit: UPDATE products SET products_price = products_price/100*116 Und mach anschlie?end: UPDATE products SET products_price = products_price/100*84 oder auch: UPDATE products SET products_price = products_price*0.84 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.