I think it depends on the datatypes you're using as inputs to the division calculation, if they are integers then it does have problems, you could try using:
(CAST(myfield AS float))/(CAST(myfield2 AS float)) if myfield1 and myfield2 are integers Alex > -----Original Message----- > From: Joshua Miller [mailto:[EMAIL PROTECTED] > Sent: 31 July 2003 16:15 > To: CF-Talk > Subject: T-SQL division drops the decimal? > > > How do others on the list deal with this? > > I have a query that takes a value from the database and > divides by 2 and > inserts that value into another table, however SQL Server > (T-SQL) drops > the decimal place, so 1/2 of 1 is 0 according to T-SQL. > > Any idea how to overcome this? That seems really odd .... if > I WANTED to > round I could use FLOOR() or CEILING() to round, why make it > the default > in T-SQL ???? > > Thanks, > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net <http://www.garrisonenterprises.net/> > [EMAIL PROTECTED] > (704) 569-0801 ext. 254 > > ************************************************************** > ********** > ************* > Any views expressed in this message are those of the > individual sender, > except where the sender states them to be the views of > Garrison Enterprises Inc. > > This e-mail is intended only for the individual or entity to > which it is > addressed and contains information that is private and > confidential. If > you are not the intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to > <mailto:[EMAIL PROTECTED]> > [EMAIL PROTECTED] > ************************************************************** > ********** > ************* > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
