Hello experts,
I'm having a trouble in SQL Query. I want to set the Price in ITM1 when the TaxCode was change into PA the Price will divided by 1.12
SELECT price, * from ITM1 where Price = '400' / 1.12
So I try in SQL SERVER 2008 I got an error
Arithmetic overflow error converting varchar to data type numeric.