Skip to Content
0
Former Member
Jan 17, 2012 at 05:25 AM

[Help]SQL Query

26 Views

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.