InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 15:19:38 GMT20http://www.sqlservercentral.com/Forums/Topic406968-145-1.aspxSUM(F1 - ROUND( F1, 0, 1) worked great. Thank you.Thu, 04 Oct 2007 13:36:00 GMTazzameinhttp://www.sqlservercentral.com/Forums/Topic406968-145-1.aspxYou cound try something like:create table #junk (float_to_add float NOT NULL)goinsert #junk(float_to_add) values (1.1104)insert #junk(float_to_add) values (1.222)insert #junk(float_to_add) values (1.32)insert #junk(float_to_add) values (1.41)insert #junk(float_to_add) values (1.52)insert #junk(float_to_add) values (1.66)insert #junk(float_to_add) values (1.71)goselect float_to_add from #junkgoselect sum(convert(numeric(13,3),float_to_add) % 1.000) from #junkgodrop table #junkgoBut float is not an exact datatype, it's an approximation, so you may get some unexpected results because a number like 1.3 might actually come out as 1.29999999999.If the numbers you're storing need definite precision, float may not be the appropriate data type.Thu, 04 Oct 2007 11:48:50 GMTDavid Webb-CDShttp://www.sqlservercentral.com/Forums/Topic406968-145-1.aspxJust use Round functionIF NOT OBJECT_ID('ANDRETEST') IS NULL DROP TABLE ANDRETESTGOCREATE TABLE ANDRETEST(F1 FLOAT, F2 CHAR(10))GOINSERT INTO ANDRETEST ( F1, F2 ) VALUES ( 160.2,'TEST')INSERT INTO ANDRETEST ( F1, F2 ) VALUES ( 100,'TEST')INSERT INTO ANDRETEST ( F1, F2 ) VALUES ( 79.5,'TEST')SELECT ROUND(SUM(F1 - ROUND( F1, 0, 1)), 1) AS TEST FROM ANDRETESTIF NOT OBJECT_ID('ANDRETEST') IS NULL DROP TABLE ANDRETESTGOThu, 04 Oct 2007 11:48:07 GMTAndre St-Ongehttp://www.sqlservercentral.com/Forums/Topic406968-145-1.aspxOn an SQL 2005 Server I have a table column filled with float values. What I want to do is sum up only the decimal portion of each value. For example, for the values:160.210079.5The sum would be .7 (.5 + .2)My problem is that I am told Decimal is not a valid function, and I really don't want to have to loop through each value in code to pull out/add the decimals.Is there a way to do this in SQL 2005?Thu, 04 Oct 2007 11:09:58 GMTazzamein