Subject | How convert field float to numeric(4,3) ? |
---|---|
Author | Gerson Machado |
Post date | 2006-04-12T21:37:44Z |
I have two field in table with float, like:
Field1 float
Field2 float
and ... need multiply Field1 by Field2 and the result truncate in a Field3 (Numeric(4,3)), but in stored procedure I receive the error:
Aritmetic overflow, .... numeric overflow...
What I need todo ?
Tks
---------------------------------
Yahoo! Messenger com voz - Instale agora e faça ligações de graça.
[Non-text portions of this message have been removed]
Field1 float
Field2 float
and ... need multiply Field1 by Field2 and the result truncate in a Field3 (Numeric(4,3)), but in stored procedure I receive the error:
Aritmetic overflow, .... numeric overflow...
What I need todo ?
Tks
---------------------------------
Yahoo! Messenger com voz - Instale agora e faça ligações de graça.
[Non-text portions of this message have been removed]