ROUNDING INSTEAD OF PRECISION 2?

[itprsn]

Having no luck trying to get precision 2 data in a stored procedure. I've tried variations of the following logic with no success. Can someone help? Thanks...

SELECT
CONVERT(DECIMAL(10,2),SUM(PRD.Pages*GrossFolder)/1000) MGP
FROM...

 

[gmmastros]

If you want to return 2 digits of precision, you need to use Decimal(x,2). You can round the number before converting it though.

Ex:

[COLOR=blue]declare[/color] @Blah [COLOR=blue]Float[/color]
[COLOR=blue]Set[/color] @Blah = 1234.5678

[COLOR=blue]Select[/color] [COLOR=#FF00FF]Round[/color](@Blah, 2)
[COLOR=blue]Select[/color] [COLOR=#FF00FF]Convert[/color]([COLOR=blue]Decimal[/color](10,2), [COLOR=#FF00FF]Round[/color](@Blah,2))

Returns....

[tt][blue]

-----------------------------------------------------
1234.5699999999999

(1 row(s) affected)


------------
1234.57

(1 row(s) affected)

[/blue][/tt]

Make sense?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLSister]

SUM(PRD.Pages*GrossFolder)/1000

are Pages and grossfolder fields also integer? YOu may be suffering from integer math issues. Try 1000.000 instead of 1000

"NOTHING is more important in a database than integrity." ESquared

 

[itprsn]

Apparently so - 1000.0000 worked. Thanks!