|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Convert when multiplying smallintsHi I have two columns of type small int that cause overflow when
multiplied. SELECT Convert(Bigint,Quantity*UnitCost) FROM Transactions SELECT Convert(varchar(12),Quantity*UnitCost) FROM Transactions Arithmetic overflow error converting expression to data type smallint. What is the correct way to select this? Thanks Try,
SELECT cast(Quantity as bigint) * UnitCost FROM Transactions AMB Show quote "hals_left" wrote: > Hi I have two columns of type small int that cause overflow when > multiplied. > > SELECT Convert(Bigint,Quantity*UnitCost) FROM Transactions > SELECT Convert(varchar(12),Quantity*UnitCost) FROM Transactions > > Arithmetic overflow error converting expression to data type smallint. > > What is the correct way to select this? > > Thanks > > Which of those statements produce the error? And do you know what values are
producing the error? Small int can go upto 32,767 "hals_left" <cc900***@ntu.ac.uk> wrote in message Hi I have two columns of type small int that cause overflow whennews:1123850544.468656.282800@g14g2000cwa.googlegroups.com... multiplied. SELECT Convert(Bigint,Quantity*UnitCost) FROM Transactions SELECT Convert(varchar(12),Quantity*UnitCost) FROM Transactions Arithmetic overflow error converting expression to data type smallint. What is the correct way to select this? Thanks SELECT Cast(Quantity as Bigint)*Cast(UnitCost as Bigint) FROM Transactions
works....but best option? Lee-Z Show quote "hals_left" <cc900***@ntu.ac.uk> wrote in message news:1123850544.468656.282800@g14g2000cwa.googlegroups.com... > Hi I have two columns of type small int that cause overflow when > multiplied. > > SELECT Convert(Bigint,Quantity*UnitCost) FROM Transactions > SELECT Convert(varchar(12),Quantity*UnitCost) FROM Transactions > > Arithmetic overflow error converting expression to data type smallint. > > What is the correct way to select this? > > Thanks > >SELECT Cast(Quantity as Bigint)*Cast(UnitCost as Bigint) FROM Transactions Thanks, that does it. |
|||||||||||||||||||||||
Other interesting topics