Click here to Skip to main content
12,349,554 members (27,623 online)
Rate this:
 
Please Sign up or sign in to vote.
i have a procedure that working fine from last five month. but now in one case the round function cannot round the figure see below:

declare @per float;
select @per=1.39
select round(((11250+0)*@per),0)

it giveing 15637 instead of 15638

15637.5= 15638

sqlserver
Posted 16-Sep-12 22:15pm
balongi1.1K

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi

convert it to decimal


declare @per float;
select @per=1.39
select CONVERT(decimal(18,3),round(((11250+0)*convert(decimal(18,3),@per)),0))



Regards
Sanju
  Permalink  
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160621.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100