Round

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Round

Round

Rate Topic

Display Mode

Topic Options

Author

Message

tali_benyehuda

Posted Sunday, February 01, 2009 7:01 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 7:21 AM
Points: 13, Visits: 129

Hi there,
I would like to round the following number: 12,999 to 13,000 and I cant find a way, all the round options are decimal rounds.
anyone has an idea? Hehe

thanks!

Post #647694

John H Marsh

Posted Sunday, February 01, 2009 7:52 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 28, 2013 1:54 AM
Points: 1,325, Visits: 1,376

Hello,

The following script will Round 12999 to 13000:-

Select Round(12999, -1)

This works for the example that you provided, but what is the underlying rounding algorithm that you need?

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

Post #647699

Jeff Moden

Posted Sunday, February 01, 2009 9:04 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:18 PM
Points: 32,910, Visits: 26,804

John is correct. To become better familiar with the ROUND function, take a look a Books Online... it has a full description and many examples to help you determine what you actually need.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #647713

« Prev Topic | Next Topic »

Permissions