DSXchange

Posted: **Tue Aug 03, 2010 1:40 pm**

I think the value 501966000102 is beyond the maximum limit of the Integer data type. Can you use target as BigInt instead of Integer?

Posted: **Tue Aug 03, 2010 2:18 pm**

Thanks, with the data type BIGINT, the result is correct.

DECIMAL(38,10) TO INTEGER(14)