Would it be because it's an integer? You may need to use CAST() or CONVERT().
Ade -----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
