Sum float with 2 digits after comma , How ?

Question

Post reply

Sum float with 2 digits after comma , How ?

birbakista

SSC Rookie

Points: 46
More actions
June 4, 2010 at 7:45 am

#222322

I need a query with sample results below :
for example i have float columns
10.125
50.2550
40.5
--------
sum=100.88
but i want this sum like this , 2 digits after comma :
10.12
50.25
40.5
--------
sum=100.87
How can i do with tsql command. Thanks ...

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

DECLARE @test TABLE (Col1 float)

INSERT INTO @test

SELECT 10.125 UNION ALL

SELECT 50.2550 UNION ALL

SELECT 40.5

SELECT sum(round(col1,2,1))

FROM @test

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

birbakista SSC Rookie Points: 46 More actions · Answer 2

birbakista

SSC Rookie

Points: 46

June 4, 2010 at 8:37 am

#1176563

Thank you very much Wayne. That's really good.